Create the directories for the databases and the log file.
phys-schost-1$ mkdir /global/mnt3/postgres/data phys-schost-1$ mkdir /global/mnt3/postgres/logs |
Change to the PostgreSQL root directory and initialize the data cluster.
phys-schost-1$ cd /global/mnt3/postgres/postgresql-8.1.0 phys-schost-1$ ./bin/initdb -D /global/mnt3/postgres/data |
Start the database.
phys-schost-1$ ./bin/postmaster -D /global/mnt3/postgresql-8.1.0 |
Prepare the Sun Cluster specific test database.
phys-schost-1$ ksh /opt/SUNWscPostgreSQL/util/pgs_db_prep -f /global/mnt3/pgs_config |
Stop the postmaster.
phys-schost-1$ ./bin/pg_ctl -D /global/mnt3/data stop |
Exit the postgres user ID.
phys-schost-1$ exit |
Run the pgs_register script to register the resource.
phys-schost-1# ksh /opt/SUNWscPostgreSQL/util/pgs-register -f /global/mnt3/pgc_config |
Add the following line to the postgresql.conf file in the PGDATA directory.
listen_addresses = 'localhost,ha-host-1' |
Add the following line to the pg_hba.conf file in the PGDATA directory.
host all all 0.0.0.0/0 password |
Enable the resource.
phys-schost-1# clresource enable RS-PGS |