Multiple Databases

hmaddy

• April 26, 2022 15:02

Currently installed mariadb 10.5 on server. But now some websites need postgresql. so how can i install multiple database software on cpanel server.

• 

  cPRex Jurassic Moderator

  • April 26, 2022 20:14

  Hey hey! "/scripts/installpostgres" will get that taken care of for you - more details on that can be found here:

  0
• 

  hmaddy

  • April 26, 2022 20:17

  Can we access these databases from phpmyadmin.??? Or how to access these databases.

  0
• 

  cPRex Jurassic Moderator

  • April 26, 2022 20:19

  Once the software is installed you'll see the PHPPgAdmin tool available in cPanel. It's PHPMyAdmin but for PostGreSQL. More details on that can be found here:

  0
• 

  hmaddy

  • April 26, 2022 20:24

  Thanks for your great help. One more doubt regarding the same. 1. By default we can access the mariadb databases via ssh also. In PostgreSQL How to access it via terminal. 2. Location of Postgresql database file storage

  0
• 

  cPRex Jurassic Moderator

  • April 26, 2022 20:25

  1 - Yes, PostGreSQL has a full command line tool available. 2 - /var/lib/pgsql is the default location.

  0
• 

  hmaddy

  • April 26, 2022 20:28

  How to access postgresql via terminal. Please share it with one example

  0
• 

  cPRex Jurassic Moderator

  • April 26, 2022 20:32

  There is a large amount of documentation out there about using the psql command line tool, such as their main site:

  0
• 

  Spirogg

  • April 26, 2022 21:35

  There is a large amount of documentation out there about using the psql command line tool, such as their main site:

  0
• 

  cPRex Jurassic Moderator

  • April 26, 2022 21:36

  That's something that isn't supported just yet.

  0
• 

  Spirogg

  • April 26, 2022 21:55

  That's something that isn't supported just yet.

  
  There is one already ill Post it here for reference. It was 17 months ago. oops 4 years ago. so I don"t want to double post another feature request unless it"s better so it"s on top and not hidden lol possibly we can get some tracking. for this one.

  0
• 

  Spirogg

  • April 26, 2022 22:01

  That's something that isn't supported just yet.

  
  

  0
• 

  hmaddy

  • April 27, 2022 01:32

  In a single account customer is using mysql and postgresql. it will work smoothly or not.?? in cpanel backup also it will work correctly or not

  0
• 

  cPRex Jurassic Moderator

  • April 27, 2022 15:58

  @hmaddy - yes, that will work fine.

  0

Please sign in to leave a comment.