Setup Postgres Databases

From Lunarpages Web Hosting Wiki

Many of the scripts and services you wish to install and get running use Postgres databases to store the information on the web site. The information is then pulled from the databases, at the request of the script and then displayed to your readers. Here we will help explain how to setup a Postgres database in cPanel.

How to Setup Postgres Databases in cPanel

First thing to start with would be to login to cPanel. Once you are in, scroll down the front page until you reach the icon that reads, "PostgreSQL Databases". Click it to be taken to the Postgres Account Maintenance web page.

Create a Postgres Database

The first thing to do is create a name for the new database. Under "Databases" you should see an empty text box with a "Db:" to the left side.

Type the name you wish to use for your database here. Make sure you make note of the name you used, and then hit the "Add Db" button.

Create a Postgres Database User

Now if you scroll down to about half way on the Postgres Database Management web page, you see a section titled, "Users". Under this text, you should see two empty text boxes. One box is for your database's user name and the other is for your user name's password. These should be unique to this database and should not be your account user name and password.

Also, make the password 6-8 alpha-numeric characters, and it should not contain the user name. Make note of both the user name and password you used, and then hit the "Add User" button.

Granting User Access to a Postgres Database

The last step would be to add the user you have created for the Postgres database to the database itself. You should see where to do this under "Users in (yourdatabasename)".

Ensure that you have the correct user name and database name selected from the drop down menus. Once you have made your selection in both of the drop down boxes, hit the button named, "Add User to Db". You have now successfully created a new Postgres database.

If you need to edit any of your database specifics, you can do so by using the phpPgAdmin link at the bottom of the Postgres Account Maintenance web page.

Please Note: This is for web hosting clients using cPanel as their control panel choice.