[pgpool-general: 4095] Fwd: Reg Automatic Fail over & Automatic Failback in Pgpool.

Gurunadh Venkata gurunadh.venkata at gmail.com
Wed Oct 7 14:17:47 JST 2015


Dear group,

I have set-up hot-standby streaming replication with two postgresql 9.3
nodes as (master-slave).

And also i have configured the pgpool on the two nodes for
connection-pooling and  pgpool High availability.

If Primary node goes down then pgpool can able to make the secondary node
as a primary.

How to make the failed primary node as a secondary  to the new primary
node.how to attach this node in pgpool setup again so that now both the
nodes are in pgpool setup.

Version of Postgres:  9.3

pgpool 3.3.6

will be down time of database services(new master) during this procedure?

Are there any scripts to make the failed primary node as slave to the new
primary node.


Thanks For Your Time.

Thanks & Regards,
G V Gurunadh.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151007/620f2035/attachment.html>


More information about the pgpool-general mailing list