[pgpool-general: 4753] How to define master node

Travis Kirstine tkirstine at firstbasesolutions.com
Mon Jul 4 21:58:13 JST 2016


I have pgpool running in watchdog mode with postgresql streaming replication.  For some reason if the master pgpool node fails or is stopped the new master will start routing database update queries to the standby postgresql node.  Do I need to define which backend is master on each pgpool node or have I done something wrong?

Regards

Travis Kirstine
Project Supervisor
140 Renfrew Drive, Suite 100
Markham, Ontario L3R 6B3 Canada
[cid:image003.png at 01D1D5D2.32361A70]<http://www.firstbasesolutions.com/>
T: 905.477.3600 Ext 267 | C: 647

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160704/bcff29cb/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3026 bytes
Desc: image001.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160704/bcff29cb/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 5584 bytes
Desc: image003.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160704/bcff29cb/attachment-0001.png>


More information about the pgpool-general mailing list