Oracle^® Solaris Cluster Data Service for PostgreSQL Guide

Example: Preparing the Cluster for PostgreSQL

1. Install and configure cluster as instructed in Oracle Solaris Cluster 4.3 Software Installation Guide.

   Install the following cluster software components on both nodes:

   • Oracle Solaris Cluster core software

   • Oracle Solaris Cluster data service for PostgreSQL

2. Install the following utility software on both nodes:

   • readline utility

   • rsync utility

   • gmake utility

   • Your C compiler

3. Beginning from the node that owns the file system, add the postgres users.

   phys-schost-1# groupadd -g 1000 postgres
   phys-schost-2# groupadd -g 1000 postgres
   phys-schost-1# useradd -g 1000 -d /global/mnt3/postgres -m -s /bin/ksh pgs
   phys-schost-2# useradd -g 1000 -d /global/mnt3/postgres -m -s /bin/ksh pgs

   ---

   Note -  For a zone cluster, perform the steps in each zone-cluster node.

   ---

4. Ensure that the PostgreSQL users can login to each other's profile using ssh without a password prompt.