Hi.
I'd like to setup HA PostgreSQL streaming replication cluster with two
nodes. The main issue which I'd like to protect from is HW node failure
or reboot. I supposed to use repmgr to control PostgreSQL cluster and
two pgpool instances as load balancers/DB proxies.
The issue which I still don't understand how to handle is temporary
master failure. Let's say, we have host A (master) and host B (slave).
Now A reboots. Pgpool (or repmgr, doesn't matter) promotes B to master.
Now A comes online (and still considers itself master). How can Pgpool
determine that A host is "bad one" and stop routing queries to A?
--
Best regards,
Alexander Pyhalov,
system administrator of Southern Federal University IT department
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
