[pgpool-general: 3552] Reg Failover Script in pgpool

[Gurunadh Venkata]

Hi all,

I have setup the pgpool for streaming replication failover in PostgreSQL.

I have two PostgreSQL servers 10.0.0.80(master) & 10.0.0.81(slave) and
pgpool running on 10.0.0.81 with port 9999.

Now i want to write a failover script where if my master pg server fails
then slave server should take the role of Master server.

Please help me in creating a failover script. I have already tried with
different failover scripts but none of them are working fine .

Please find the attached pgpoog.conf, pgpool logs failover script files and
please let me Know if any changes required.

Thanks for your time..

Thanks & Regards,
G V Gurunadh.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150319/cea86ed3/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 30829 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150319/cea86ed3/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: failover.sh
Type: application/x-sh
Size: 794 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150319/cea86ed3/attachment.sh>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: failover.sh1
Type: application/octet-stream
Size: 390 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150319/cea86ed3/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ppas-pgpool-enterprisedb.log
Type: application/octet-stream
Size: 130628 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150319/cea86ed3/attachment-0002.obj>