Postgre SQL is a database management system based on Unix platform. It allows you to add, access, and process stored data. The SQL part of PostgreSQL stands for "Structured Query Language" - the most common standardized language used to access databases.

• Creating Postgre SQL users
• Deleting users and changing their passwords
• Creating Postgre SQL databases
• Editing Pg SQL databases and user privileges (php Pg Admin)
• Changing Pg SQL quota.

Creating Postgre SQL User(s)

Unlike with other databases, a Postgre SQL database cannot be created without a user. You must stick to the following sequence:

1. Create a Postgre SQL user.
2. Create a database.

Note: The first user in the list of users is the owner of a database, however the database can be used by others who obtain permissions from the owner.

To create a Postgre SQL database user, do the following:

1. Select PGSQL in the Databases menu and Add Postgre SQL user form automatically appears.
2. Fill the Add Postgre SQL user form on the Postgre SQL Users page.



3. Agree to additional charges.

Deleting Users and changing their passwords.

To delete the PgSQL database user, do the following:

1. Select PGSQL Users in the Databases menu.
2. Click the Trash icon next to the user name on the Postgre SQL user management page.
3. Agree to additional charges.

Important: Trash icon appears only next to non-owners. The owner of a database cannot be deleted, unless you remove the Postgre SQL database.

To change the user password, do the following:

1. Select PGSQL Users in the Databases menu.
2. Click the Change icon next to the name of the user.
3. Enter a new password, confirm it, and click Change.

Important: the user privileges can be changed by means of phpPgAdmin.

Creating Postgre SQL Databases

Having at least one user, you can create a Postgre SQL database. This user will become the owner of this database.

To create a database, do the following:

1. Select PGSQL DBs in the Databases menu.
2. Click Add Database in the Postgre SQL Databases section:
   

   

3. Enter the name and description of the database:



4. Click Submit and agree to additional charges.

Editing PgSQL Databases and User Privileges

You can edit the content of your databases and user privileges using the php Pg Admin utility that comes with your control panel.

To run php Pg Admin, do the following:

1. Select PGSQL DBs in the Databases menu.
2. Click the name of the database you would like to edit.

You can also start this utility from the PGSQL database management page:

1. Select PGSQL DBs in the Databases menu.
2. Click the Edit icon for the database you are going to edit:



3. In the form that appears, click Built in php Pg Admin control panel to start editing your database:



4. Follow the instructions of the phpPgAdmin control panel to edit your PgSQL DB.

Changing PgSQL disk quota.

PgSQL disk quota is the maximum allowed size of one PgSQL database. If you exceed this quota, you'll be charged for over limit at a different (usually higher) price.

To change PgSQL disk quota, do the following:

1. Select PGSQL DBs in the Databases menu.
2. Click PGSQL Database.
3. Click the Change icon in the Quota field:



4. Enter the new quota.
5. Click Submit.
6. Agree to additional charges.