[pgpool-general: 2527] Sharing PostgreSQL states between PgPool-II instances
Theron Luhn
theron at luhn.com
Tue Feb 4 10:45:56 JST 2014
In order to achieve a high level of availability for Postgres, I have two
Postgres servers (master-standby streaming replication) behind two
PgPool-II servers.
I need these two PgPool-II servers to exchange information about the state
of the Postgres servers, so that one Postgres server doesn't get promoted
to master by one PgPool-II server, but the other PgPool-II is unaware and
continues to send queries to the old master.
To do this I need watchdog correct?
I've been reading the watchdog docs, and it seems to insist on using a
virtual IP. However, virtual IP is not an available option for me. How
can I configure watchdog without the virtual IP, just taking advantage of
information sharing?
-- Theron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140203/bbb886d6/attachment.htm>
More information about the pgpool-general
mailing list