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

Tatsuo Ishii ishii at postgresql.org
Mon May 28 11:48:12 JST 2012


[Cced: to the list. Please post to the mailing list to share info]

> Hi,
>    According to your guide, is it both PostgreSQL servers are the same
> configuration?

Yes.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> On 5/28/12, Tatsuo Ishii <ishii at postgresql.org> wrote:
>> Forgot to say, the doc:
>>> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting2/index.html
>>
>> is obsoleted and hadn't been updated (actually whole
>> pgpool.projects.postgresql.org is obsoleted).  Now we have our own
>> site: http://www.pgpool.net
>>
>> The doc you want to look into is:
>> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/index.html
>> or
>> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.0/index.html
>>
>> The former is for pgpool-II 3.1.x and latter is for pgpool-II 3.0.x.
>> (there are only very subtle difference though).
>>
>> If you follow the instruction any of above, pgpool log is here:
>>
>> /var/log/pgpool/pgpool.log.week_of_the_day
>>
>> where week_of_the_day is monday, tuesday... sunday.
>>
>> PostgreSQL logs is /home/postgres/data/pg_log/week_of_the_day.log
>>
>> where week_of_the_day is Monday, Tuesday... Sunday.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>>> Hi,
>>>     Sorry, I'm very new to pgpool. How can i check the log?
>>> Thanks
>>>
>>> On 5/28/12, Tatsuo Ishii <ishii at postgresql.org> wrote:
>>>> 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
>>>>
>>>
>>>
>>> --
>>> Best Regards,
>>> Freddy
>>
> 
> 
> -- 
> Best Regards,
> Freddy


More information about the pgpool-general mailing list