Multiple Databases

[hmaddy]

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]

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-

 

[hmaddy]

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

 

[cPRex]

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:

phpPgAdmin | cPanel & WHM Documentation

Use this interface to manipulate PostgreSQL® databases.

docs.cpanel.net

 

[hmaddy]

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]

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

 

[hmaddy]

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

 

[cPRex]

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

psql

psql psql — PostgreSQL interactive terminal Synopsis psql [option...] [dbname [username]] Description psql is a terminal-based front-end to PostgreSQL. It …

www.postgresql.org

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

1.4. Accessing a Database

1.4. Accessing a Database # Once you have created a database, you can access it by: Running the PostgreSQL interactive terminal …

www.postgresql.org

 

[Spirogg]

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

psql

psql psql — PostgreSQL interactive terminal Synopsis psql [option...] [dbname [username]] Description psql is a terminal-based front-end to PostgreSQL. It …

www.postgresql.org

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

1.4. Accessing a Database

1.4. Accessing a Database # Once you have created a database, you can access it by: Running the PostgreSQL interactive terminal …

www.postgresql.org

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?

 

[cPRex]

That's something that isn't supported just yet. <looks at feature request link in signature.........................................>

 

[Spirogg]

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.

 

[Spirogg]

That's something that isn't supported just yet. <looks at feature request link in signature.........................................>

Run both MySQL and MariaDB on the same server

As a server administrator and web hosting provider I would like cPanel to provide the option to have both MySQL and MariaDB on the same server, so that I (

features.cpanel.net

 

[hmaddy]

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

 

[cPRex]

@hmaddy - yes, that will work fine.