hmaddy

Well-Known Member
May 6, 2020
278
35
28
Chennai
cPanel Access Level
Root Administrator
Currently installed mariadb 10.5 on server. But now some websites need postgresql. so how can i install multiple database software on cpanel server.
 

hmaddy

Well-Known Member
May 6, 2020
278
35
28
Chennai
cPanel Access Level
Root Administrator
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
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
11,850
1,882
363
cPanel Access Level
Root Administrator
There is a large amount of documentation out there about using the psql command line tool, such as their main site:


Specifically, you'll want the actual "how to access a database" section here:

 
  • Like
Reactions: Spirogg

Spirogg

Well-Known Member
Feb 21, 2018
700
157
43
chicago
cPanel Access Level
Root Administrator
There is a large amount of documentation out there about using the psql command line tool, such as their main site:


Specifically, you'll want the actual "how to access a database" section here:

Hey hey! "/scripts/installpostgres" will get that taken care of for you - more details on that can be found here: https://support.cpanel.net/hc/en-us...postgres-pgsql-should-I-install-on-my-server-
is there a way to have both MySQL and MariaDB as well. so users can choose between ?
this would be nice if its possible and both can be controlled from WHM as well?
 

Spirogg

Well-Known Member
Feb 21, 2018
700
157
43
chicago
cPanel Access Level
Root Administrator
That's something that isn't supported just yet. <looks at feature request link in signature.........................................>
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.
 
Last edited:
  • Like
Reactions: cPRex

Spirogg

Well-Known Member
Feb 21, 2018
700
157
43
chicago
cPanel Access Level
Root Administrator
That's something that isn't supported just yet. <looks at feature request link in signature.........................................>
 
  • Like
Reactions: cPRex

hmaddy

Well-Known Member
May 6, 2020
278
35
28
Chennai
cPanel Access Level
Root Administrator
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