[pgpool-general: 523] Re: Guide on setup pgpool for automatic failover

Tatsuo Ishii ishii at postgresql.org
Mon May 28 10:27:36 JST 2012


Please show us pgpool log and PostgreSQL log of both primary and stanby.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I have follow exactly with this guide
> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting2/index.html
> 
> When i start the pgpool by using pgpoolAdmin, i get this:
> error code:e1002 which is pcp_node_count command error occurred.
> error code:e1004 which is pcp_proc_count command error occurred.
> error code:e1006 which is pcp_stop_pgpool command error occurred.
> 
> What to do with this problem?
> 
> Thank you
> 
> On 5/25/12, Wolf Schwurack <wolf at uen.org> wrote:
>> Have you look at recovery.conf, you can use that for automatic fail-over
>>
>>       0___      Wolfgang Schwurack
>>      c/  /'_    SA/DBA - UEN
>>     (*)  \(*)   801-587-9444
>>                 wolf at uen.org
>>
>>
>>
>>
>> On 5/25/12 2:50 AM, "Freddy Liaw" <freddyliaw at softmy.net> wrote:
>>
>>>I have 2 ubuntu server with postgresql installed (hot standby +
>>>streaming replication)
>>>Work fine with streaming replication.
>>>
>>>the problem is only i need automatic fail-over.
>>>
>>>Any help will greatly appreciated.
>>>
>>>--
>>>Best Regards,
>>>Freddy
>>>_______________________________________________
>>>pgpool-general mailing list
>>>pgpool-general at pgpool.net
>>>http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
> 
> 
> -- 
> Best Regards,
> Freddy
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list