**************************************
* README for OCF-script: postgres.sh *
**************************************

Example OCF(Open Cluster Framework)-script for PostgreSQL version 8.2.4. 
This example script could be used to manage a PostgreSQL database instance in a clustered environment (for example with the Red Hat 5 cluster suite).

This script is intended to work with a cluster manager following the Open Cluster Framework standard.
It was developed and tested with the Red Hat Enterprise Linux 5 Cluster Suite in combination with PostgreSQL version 8.2.4.

Default storage path of this script: "/usr/share/cluster/cluster.sh" (required on all cluster nodes)

Description of parameters in the script:
- name: 		unique name 
- pgdata: 		PGDATA-directory 
- hostname: 		Hostname of PostgreSQL DB instance 
- username: 		User name who can login on the database (without password -> trust) 
- databasename: 	Database for the user to connect to 
- resource_timeout: 	Timeout for actions (start, stop, status query) 

Status checks will be performed as follows:
	psql –h <hostname> -U <username> <databasename> -l.


The cluster and service configuration itself has to be set up correctly as usual.
Example configuration for PostgreSQL resources: (modify parameters as needed) 
	<postgres name="postgresql_vts1" pgdata="/data1/db1/pgdata" hostname="pg-node1" username="postgres" databasename="postgres" resource_timeout="10"/>
	<postgres name="postgresql_vts2" pgdata="/data2/db1/pgdata" hostname="pg-node2" username="postgres" databasename="postgres" resource_timeout="10"/> 
 


---
If you need more information on this script, 
please contact the Fabalabs Software GmbH
Web: 	http://www.fabalabs.org
E-Mail: support@fabalabs.org