Installing PostgreSQL

To install PostgreSQL on your Virtual Private Server, connect to your
server via Telnet or SSH and run the following command:

% vinstall pgsql

The PostgreSQL installation includes all the necessary PostgreSQL files, initializes a database
with the same name as your user name, and activates the postmaster daemon. Several wrapper
scripts are available for all PostgreSQL commands. The wrapper scripts are automatically created
when PostgreSQL is installed.

PostgreSQL is installed in a version-specific directory (~/usr/local/pgsql-7.X.X)
and a symlink named pgsql is created that points to that directory.

Configuration

To configure PostgreSQL (which is optional), add the following lines to your shell startup file,
according to which shell your Virtual Private Server is running.

NOTE: To find out which shell your server is running, type:

% echo $SHELL

/bin/csh
If you are using /bin/csh or one of its variants, then add the following lines to the
~/.cshrc file on your Virtual Private Server.

This program will read your password file at ~/etc/passwd and create a Berkeley
DB format file. PostgreSQL uses this new file to look up user names and account information.

Multi-Language Abilities in PostgreSQL

PostgreSQL allows for a number of languages by enabling specific character-sets in the databases. When you create a database in PostgreSQL, you can use the -E flag to enable support for a specific character set.

% initdb -E SET

The following is a list of the available character sets and the SET name to use to enable support for it.

Determine the process ID of the PostgreSQL daemon and use kill to stop the PostgreSQL
daemon:

% kill PROCESS-ID

Please note: the information on this page applies to ITS web hosting plans. It may or may not apply to other environments. If you are looking for a feature described here, or better support from your hosting provider, please consider hosting your site with ITS!