[pgpool-general: 1561] Re: pgpool 3.2.3 node gets down after some hours of work.

[Dzmitry]

Yes, I will update pgpool version over the weekend, btw - is it safe use
V3_2_STABLE from git on production machine ?
Thanks,
  Dzmitry





On 3/29/13 3:16 PM, "Tatsuo Ishii" <ishii at postgresql.org> wrote:

>Can you try with V3_2_STABLE from git repository? We recently fixed
>some issues with connecting to PostgreSQL backend. This may or may not
>be related to your problem.
>
>http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=04a655560123da7
>99a83b1b34d09db0ae6d0bc44
>--
>Tatsuo Ishii
>SRA OSS, Inc. Japan
>English: http://www.sraoss.co.jp/index_en.php
>Japanese: http://www.sraoss.co.jp
>
>> Dear all,
>> 
>> I am using postgres 9.2 with streaming replication. I have 1 master DB
>>and
>> 2 standby DBs, it's hosted on amazon EC2, each has it's own server. On
>> separate server i have pgpool(3.2.3) that do load balancing(in pgpool
>> config i have num_init_children=290, max_pool- 2, child_life_time -
>> 0child_max_connections - 100, connection_life_time- 100,
>>client_idle_limit
>> - 0. do not cache onnections.). Sometimes pgpool show server status as
>> "down", but actually server is up & running fine, due to this, i am
>> getting a lot of issues.
>> Also i have in pgpool config:
>> health_check_timeout - 60
>> health_check_period - 30
>> health_check_max_retries - 3
>> health_check_retry_delay -5
>> Also pgpool is not writing log :(
>> i setup it
>> log_destination "stderr"
>> debug_level 0
>> logdir /var/tmp - i checked permissions it has 777, so it's not the
>>case.
>> when i start pgpool i start it with "-n" option to let it write log.
>> 
>> Any ideas why server shown as down & where is my logs ?
>> 
>> 
>> 
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general