[pgpool-general: 524] Re: Guide on setup pgpool for automatic failover
Tatsuo Ishii
ishii at postgresql.org
Mon May 28 11:38:57 JST 2012
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
More information about the pgpool-general
mailing list