HA-postgresql

The ARCO feature in N1GE6 require a database to store the data. Right now one can use postgresql or oracle. In case one may want to protect the database server in Solaris env, one could use the HA-oracle agent to protect the oracle database.

For postgresql database, one can use the Java ES Cluster SW's Sunplex agent builder to build an failover agent based on GDS to protect the postgresql database.

We assume the uid for postgresql is postgres, the data is stored in /shared/pgsql/data and the binary is installed in /usr/local/pgsql.

We create two scripts:

  • start_pqsql.sh

    su - postgres -c " /usr/local/pgsql/bin/pg_ctl start -l logfile /shared/pgsql/data "

  • stop_pgsql.sh

    su - postgres -c " /usr/local/pgsql/bin/pg_ctl stop -l logfile /shared/pgsql/data "

Please check my our weblog for the other step to create HA-pgsql agent.
Comments:

Post a Comment:
Comments are closed for this entry.
About

hstsao

Search

Top Tags
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today