« December 2009
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
31
  
       
Today

Blog::Navigation

Blog::Editing

Bookmarks::Blogroll

Blog::Referrers

Today's Page Hits: 645

Site notes

This page validates as XHTML 1.0, and will look much better in a browser that supports web standards, but it is accessible to any browser or Internet device. It was created using techniques detailed at glish.com/css/.

Powered by Roller Weblogger.
« Infiniband Switches | Main | parallel FS for ... »
Sunday Sep 26, 2004

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.
Copyright (C) 2003, hstsao