[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.sraoss.jp/pipermail/pgpool-general/attachments/20140203/bbb886d6/attachment.html>


More information about the pgpool-general mailing list