PostgreSQL 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. my fantasy wedding free trial

• Creating PostgreSQL users
• Deleting users and changing their passwords
• Creating PostgreSQL databases
• Editing PgSQL databases and user privileges (phpPgAdmin)
• Changing PgSQL quota.

 my fantasy wedding free trial

Creating PostgreSQL User(s)my fantasy wedding free trial

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

1. Create a PostgreSQL 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.
my fantasy wedding free trial

To create a PostgreSQL database user, do the following:my fantasy wedding free trial

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

my fantasy wedding free trial

3. Agree to additional charges.

 my fantasy wedding free trial

Deleting Users and changing their passwords.my fantasy wedding free trial

To delete the PgSQL database user, do the following:my fantasy wedding free trial

1. Select PGSQL Users in the Databases menu.
2. Click the Trash icon next to the user name on the PostgreSQL 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 PostgreSQL database.my fantasy wedding free trial

my fantasy wedding free trial

 my fantasy wedding free trial

To change the user password, do the following:my fantasy wedding free trial

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.my fantasy wedding free trial

my fantasy wedding free trial

Creating PostgreSQL Databasesmy fantasy wedding free trial

Having at least one user, you can create a PostgreSQL database. This user will become the owner of this database.
my fantasy wedding free trial

To create a database, do the following:my fantasy wedding free trial

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

   my fantasy wedding free trial

3. Enter the name and description of the database:

my fantasy wedding free trial

4. Click Submit and agree to additional charges.

 my fantasy wedding free trial

Editing PgSQL Databases and User Privilegesmy fantasy wedding free trial

You can edit the content of your databases and user privileges using the phpPgAdmin utility that comes with your control panel. my fantasy wedding free trial

To run phpPgAdmin, do the following: my fantasy wedding free trial

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:my fantasy wedding free trial

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

my fantasy wedding free trial

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

my fantasy wedding free trial

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

 my fantasy wedding free trial

Changing PgSQL disk quota.my fantasy wedding free trial

PgSQL disk quota is the maximum allowed size of one PgSQL database. If you exceed this quota, you'll be charged for overlimit at a different (usually higher) price.my fantasy wedding free trial

To change PgSQL disk quota, do the following:my fantasy wedding free trial

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

   my fantasy wedding free trial

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