| Hosting
PostgreSQL Databases |
| 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. •Creating PostgreSQL
users
•Deleting users and changing their passwords
•Creating PostgreSQL databases
•Editing PgSQL databases and user privileges
(phpPgAdmin)
•Changing PgSQL quota. |
| Creating PostgreSQL
User(s) |
| 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.
To create a PostgreSQL database user, do the
following:
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.
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 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.
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 PostgreSQL
Databases |
| Having at least
one user, you can create a PostgreSQL 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 PostgreSQL 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 phpPgAdmin utility that comes with
your control panel.
To run phpPgAdmin, 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
phpPgAdmin 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 overlimit 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 |
