[pgpool-general: 1691] Re: pgpool and failover

[Jayadevan M]

Oh, OK. I did pgpool --help and it was there too.
Apologies...
Regards,
Jayadevan


>-----Original Message-----
>From: Tatsuo Ishii [mailto:ishii at postgresql.org]
>Sent: Wednesday, May 08, 2013 8:36 AM
>To: Jayadevan M
>Cc: wolf at uen.org; pgpool-general at pgpool.net
>Subject: Re: [pgpool-general: 1689] Re: pgpool and failover
>
>I think Wold refers to pgpool.8.in file.
>--
>Tatsuo Ishii
>SRA OSS, Inc. Japan
>English: http://www.sraoss.co.jp/index_en.php
>Japanese: http://www.sraoss.co.jp
>
>> Hi,
>> It is there, but not very obvious -
>> http://www.pgpool.net/docs/latest/pgpool-en.html
>> Scroll down, you will find
>> -D           --discard-status                Discard pgpool_status file and do not restore
>previous status
>>
>> From: Wolf Schwurack [mailto:wolf at uen.org]
>> Sent: Wednesday, May 08, 2013 1:23 AM
>> To: Jayadevan M
>> Cc: 'pgpool-general at pgpool.net'
>> Subject: RE: pgpool and failover
>>
>> That option is not in the man pages for pgpool.
>> It's good to know because I have pgpool failover a few time because it lost
>the connection to the primary. Then I had to reboot the server to get pgpool
>connect to the primary again.
>>
>> Thanks
>> Wolf
>>
>> From: Jayadevan M
>[mailto:jayadevan.maymala at ibsplc.com]<mailto:[mailto:jayadevan.maymala
>@ibsplc.com]>
>> Sent: Monday, May 06, 2013 9:29 PM
>> To: Wolf Schwurack
>> Cc: 'pgpool-general at pgpool.net'
>> Subject: RE: pgpool and failover
>>
>> Hi,
>> Like this -
>> pgpool    -d -D -f /etc/pgpool.conf   > /tmp/pgpool.log 2>&1
>>
>> The -d option runs it in debug mode
>> -D option makes it 'ignore' existing status and start afresh. So it discards the
>fact that it had 'failed over' to the secondary server and connects to the
>primary server.
>> -f tells it which configuration file to use
>>
>> Regards,
>> Jayadevan
>>
>> From: Wolf Schwurack [mailto:wolf at uen.org]
>> Sent: Monday, May 06, 2013 6:43 PM
>> To: Jayadevan M
>> Subject: RE: pgpool and failover
>>
>> Can you share on how you did this
>>
>> Thanks
>>
>> Wolf
>>
>> From: pgpool-general-bounces at pgpool.net<mailto:pgpool-general-
>bounces at pgpool.net> [mailto:pgpool-general-
>bounces at pgpool.net]<mailto:[mailto:pgpool-general-
>bounces at pgpool.net]> On Behalf Of Jayadevan M
>> Sent: Monday, May 06, 2013 2:26 AM
>> To: 'pgpool-general at pgpool.net'
>> Subject: [pgpool-general: 1683] Re: pgpool and failover
>>
>> Hi,
>> Answering my own question -
>> Use -D option.
>> Regards,
>> Jayadevan
>>
>> From: Jayadevan M
>> Sent: Monday, May 06, 2013 1:14 PM
>> To: 'pgpool-general at pgpool.net'
>> Subject: pgpool and failover
>>
>> Hi,
>>
>> I am testing pgpool with streaming replication. There is one master and one
>slave. When I shut down the master, the requests were redirected to the
>slave. So far so good. I want to test a few more scenarios. Now that I have the
>primary master up, how do I make pgpool send connections to the master? It
>is still sending all requests to the slave.
>>
>> Regards,
>> Jayadevan M
>> Senior Technical Architect - TCC
>> IBS Software Services Private Limited
>> 5th Floor/NILA, Technopark Campus, Trivandrum 695 581, Kerala, India
>> Phone: +91- 471-6614352 Mobile: +91 94952 00950
>> Email:
>Jayadevan.Maymala at ibsplc.com<mailto:Jayadevan.Maymala at ibsplc.com>
>www.ibsplc.com<http://www.ibsplc.com/>
>>
>>
>>
>> DISCLAIMER: "The information in this e-mail and any attachment is intended
>only for the person to whom it is addressed and may contain confidential
>and/or privileged material. If you have received this e-mail in error, kindly
>contact the sender and destroy all copies of the original communication. IBS
>makes no warranty, express or implied, nor guarantees the accuracy,
>adequacy or completeness of the information contained in this email or any
>attachment and is not liable for any errors, defects, omissions, viruses or for
>resultant loss or damage, if any, direct or indirect."
>>
>>
>> DISCLAIMER: "The information in this e-mail and any attachment is intended
>only for the person to whom it is addressed and may contain confidential
>and/or privileged material. If you have received this e-mail in error, kindly
>contact the sender and destroy all copies of the original communication. IBS
>makes no warranty, express or implied, nor guarantees the accuracy,
>adequacy or completeness of the information contained in this email or any
>attachment and is not liable for any errors, defects, omissions, viruses or for
>resultant loss or damage, if any, direct or indirect."
>>
>>
>> DISCLAIMER: "The information in this e-mail and any attachment is intended
>only for the person to whom it is addressed and may contain confidential
>and/or privileged material. If you have received this e-mail in error, kindly
>contact the sender and destroy all copies of the original communication. IBS
>makes no warranty, express or implied, nor guarantees the accuracy,
>adequacy or completeness of the information contained in this email or any
>attachment and is not liable for any errors, defects, omissions, viruses or for
>resultant loss or damage, if any, direct or indirect."


DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."