HostMonster Web Hosting Help

PostgreSQL

Summary

This article will explain how to manage the PostgreSQL Databases on your account.

Managing PostgreSQL Databases
Managing User
Enabling PL/pgSQL
Using SSH

Managing PostgreSQL Databases

To create a database from the PostgreSQL Databases Icon.

Under theDatabase Tools section, click the PostgresSQL Databases icon.

In the New Database field, type a name for the database.

Click Create Database.

Click Go Back to manage databases.

Managing User

After creating the database, a user will need to be created and their privileges added to the newly created database. Please note that PostgreSQL user accounts must be created separately from mail, MySQL, and web administrator accounts.

Creating a PostgreSQL User

To quickly access the PostgreSQL Users, click Jump to PostgreSQL Users.
Under Add New User, enter a Username.

Note:

Enter a password in the Password field.
Retype the password in the Password (Again) field.
Click Create User.

Add a User to a Database

Privileges define how the user is able to interact with the database. For example, they will determine whether or not the user can add and delete information.

Managing Privileges

Under Add User to Database, select a user from the User drop-down menu.
From the Database drop-down menu, select the database to which you wish to allow the user access.
Click Add.
From the PostgreSQL Account Maintenance screen, select the privileges you wish to grant the user, or select ALL PRIVILEGES.
Click Make Changes.

Enabling PL/pgSQL

PL/pgSQL can be enabled on your databases individually by our Level III technicians. Also, if you wish to have the function plpgsql_call_handler() created in your database, please make sure you mention it, since this is no longer done automatically.