From OpenSCG Wiki

OpenSCG provides PostgreSQL 9.1 DEB packages for an easy installation experience on Ubuntu 8+ distributions. This tutorial explains how to install and configure PostgreSQL using OpenSCG's deb packages.

Requirements

Appropriate 32 or 64 bit PostgreSQL 9.1 deb package from OpenSCG.

Installation Steps

The installation of PostgreSQL 9.1 server is very easy. To install:

• Download and save deb package.

• Install the deb package as sudo

PostgreSQL is cleanly installed to the "/opt/postgres/9.1" directory without changing any other shared libraries on your system. All the libraries that PostgreSQL uses are in the "/opt/postgres/9.1/lib" directory to minimize the chances of conflicts and other incompatibilities.

Configure and initializing PostgreSQL Server

OpenSCG's server control script makes it very easy to configure the PostgreSQL server. The start command will attempt to initialize the server on its first usage (technically in the absence of data directory).

• Enter following command in your shell prompt (as sudo):

• You will be prompted to provide database server port,superuser password and server startup options. You can either press <ENTER> for default values,or you can provide your own customized inputs. Following the inputs,the database cluster will be initialized and server will be started.

• The server can now be controlled by either using invoke-rc.d command and/or by calling the init script directly:

The server is controlled by postgres operating system user,which will be created (as a locked account) by the configuration script if it does not already exists.

Setting the Environment and Using the database

The OpenSCG's deb package does not do anything to your system environment in order to prevent conflicts with other software. If you wish to load the environment for this install,you can use the included env file:

This will load:

* PGHOME
* PGDATA
* PATH
* LD_LIBRARY_PATH
* PGUSER
* PGDATABASE
* PGPORT

Default database

The default database created at initialization time (as with most other PostgreSQL packages) is:

   postgres

Default username

The default superuser created at initialization time (as with most other PostgreSQL packages) is:

   postgres

Default password

The default password (unless you set it at initialization time) is:

   password

Change the default password

To change the default password,you first need to login to the database with your current password:

Now,change the password for the postgres user:

Now your password is changed.

Forgot my password!

If you've forgotten your password,that's no problem. Here's the reset process:

• Use sudo or become postgres user. (Note: postgres might be locked,in which case you must use sudo - or unlock postgres account)

• Edit the pg_hba.conf (host based access) file using your favorite editor

• Change highlighted line

by changing connection method from md5 to trust:

• Save your changes

• Command postgres to re-read it's config file (either using sudo or as postgres user)

• Login to the database (you will not be prompted for password).

• Change the password (as described in previous section)

• Edit the pg_hba.conf (host based access) file and change trust back to md5 and reload the server.

Uninstalling PostgreSQL Server

The uninstallation of PostgreSQL server can be performed as follows by using dpkg:

Note 1: The data folder is not deleted after uninstallation.
Note 2: The dpkg warnings can be safely ignored.

Reporting Bugs/Suggestions

If you have any questions related to deb installation,or you would like to report any bugs and/or suggestions in OpenSCG's deb packaging,feel free to join OpenSCG mailing list to discuss.