PostgreSQL HA via three host, include two postgresql (primary and stream replication standby) and one vote host.
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is 37 commits behind digoal:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
INSTALL.txt
README.md
TUTORIAL.txt
check_sky_pg_clusterd_alive.sh
check_standby_lag.sh
example.pgpass
log_filter.sh
postgresql.example.conf
recovery.example.conf
sky_pg_clusterd.sh
sky_postgresql_cluster.example.sql

README.md

sky_postgresql_cluster

sky_postgresql_cluster is a PostgreSQL HA module write in shell, HA via three host, include two postgresql

(primary and stream replication standby) and one vote host. Applicatoin connect to sky_postgresql_cluster via a virtual

ip address.

Requirement :

  1. three host

  2. the two postgresql host must have fence device.

  3. the two PostgreSQL host, one is master, another is standby. standby build with PostgreSQL's stream replication.

  4. sky_postgresql_cluster's status monitor use nagios.

Author : Digoal.zhou

Email : digoal@126.com

Blog : http://blog.163.com/digoal@126/