You can create a PostgreSQL database in cPanel -> PostgreSQL Databases.
Creating New Database
Enter a database name in the New Database text box and then click Create Database.
You can rename or remove a PostgreSQL database from the Current Databases section.
Each new PostgreSQL database contains a schema named “public“.
Creating New Users
In order to be able to manage the PostgreSQL database you first need to create a user.
Enter a username (1). The username should not match any existing database name.
Enter and confirm the password (2).
We recommend that you use the Password Generator (3) to create a strong combination of uppercase and lowercase letters and numbers.
Finish the setup by clicking Create User.
Type in all the letters a username consists of when you enter it, e.g. cpuser_dbuser.
Adding User to the Database
To assign a user with a database, specify a user you would like to give permissions to from the “User” drop-down menu.
Then select a database from the “Database” drop-down menu.
The specified user is given all permissions by default so that he can manage the whole database content.
Finish the setup by clicking on “Submit“.
Connecting an Application to the Database
If you want to enable an exchange between an application and the database, you need to enter the following information:
“host=localhost;port=5432;dbname=cpuser_mypgdb;user=cpuser_mypgusr;password=password”
Host: localhost
Port: 5432
Database: the database name with prefix
Database user: the username with prefix
Password: user password
