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 User(s)
Unlike with other databases, a PostgreSQL
database cannot be created without a user. You must
stick to the following sequence:
- Create a PostgreSQL user.
- 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:
- Click the PostgreSQL Server icon on
your control panel home page.
- At the bottom of the page that shows, click
the Add user icon to start creating a
new user.
- Fill the Add PostgreSQL user form on
the PostgreSQL Users page.
Deleting
Users and changing their passwords.
To delete the PgSQL database user,
do the following:
- Click the PostgreSQL Server icon
on your control panel home page.
- Click the Trash icon next to the
user name on the PostgreSQL user management
page.
- 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:
- Click the PostgreSQL Server icon
on your control panel home page.
- Click the Change icon next to the
name of the user.
- 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:
- Click the PostgreSQL Server icon
on your control panel home page.
- Click Add Database in the PostgreSQL
Databases section:
- Enter the name and description of the database:
- Click Submit
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:
- Click the phpPgAdmin icon on the
control panel home page.
- Click the name of the database you would
like to edit.
You can also start this utility
from the PGSQL database management page:
- Click the PostgreSQL Server icon
on your control panel home page.
- Click the Edit icon for the database
you are going to edit:
- In the form that appears, click Built
in phpPgAdmin control panel to start editing
your database:
- Follow the instructions of the phpPgAdmin
control panel to edit your PgSQL DB.
