Install, Configure, and Start PostgreSQL

Primary Server

On your Primary server, perform the following actions:

1. Install both the “postgresql-server” and “postgresql” rpm packages if they do not exist on your system. Apply any required dependencies as well

# yum install postgresql postgresql-server

2. Verify that your Shared iSCSI LUN is still mounted at /var/lib/pgsql via the “df” command

3. If this is a fresh PostgreSQL install, initialize a sample PostgreSQL database:

# # : su – postgres

# initdb --pgdata=/var/lib/pgsql/data

4. Ensure that all files in your PostgreSQL data directory (/var/lib/pgsql) have correct permissions and ownership

# chown –R postgres:postgres /var/lib/pgsql

# chmod 755 /var/lib/pgsql

5. Finally, manually start the PostgreSQL daemon from the command line. Note: Do Not start it via the “service” command, or the /etc/init.d/ scripts

# su – postgres

# pg_ctl start -D /var/lib/pgsql/data -l /var/lib/pgsql/pgstartup.log -o “-p 5432” -w

6. Verify PostgreSQL is running by connecting with the psql client (ensure you are still running as the “postgres” linux user):

-bash-3.2$ psql

Welcome to psql 8.1.22, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms

\h for help with SQL commands

\? for help with psql commands

\g or terminate with semicolon to execute query

\q to quit

postgres=# \q

-bash-3.2$

Secondary Server

On your Secondary Server:

1. install both the “postgresql” and “postgresql-server” rpm packages if they do not exist on your system. Apply any required dependencies as well

# yum install postgresql postgresql-server

2. Ensure that the PostgreSQL data directory (/var/lib/pgsql) has correct permissions and ownership

# chown –R postgres:postgres /var/lib/pgsql

# chmod 755 /var/lib/pgsql

3. There is no need to perform any of the additional steps taken on the Primary Server