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

[Dzmitry]

I installed & configured pgpool using this guide
http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.0/ .
But I found issue with log - you made me thinking, thank you. The issue
was I haven't /usr/sbin/rotatelogs2 but I have /usr/sbin/rotatelogs.
I will monitor log to check why my node goes down.
One more question - my production application is connected to pgpool & it
do load balancing. When application write data - pgpool send queries to
master DB & master do streaming replication with delay. But application
can do read very quickly - and pgpool can send query to standy DB where
changes is not synchronized yet.(for example user signup: 1 signup, 2 -
show protected page - here data can be not synchronized). Is it possible
to resolve this situation with pgpool somehow ? Does it have option to
send query to specified DB ? Or I need to connect my production
application server to master DB directly, but servers that do background
processing - can be connected to pgpool ?


Thanks,
  Dzmitry





On 3/29/13 2:24 AM, "Lonni J Friedman" <netllama at gmail.com> wrote:

>On Thu, Mar 28, 2013 at 4:10 PM, Dzmitry <dzmitry.nikitsin at gmail.com>
>wrote:
>> 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 ?
>>
>
>Your logs would indicate why the nodes are down.  As for where they
>are, you'd have to tell us.  How did you install & configure pgpool?