Tatsuo what information from me, can help you to <span id="result_box" class="short_text" lang="en"><span class="hps">diagnose the problem</span></span>? I am ready to describe to you my configuration for pgpool and postgresql.<br>
<br><div class="gmail_quote">2012/5/22 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I don't know about your configurations where each server is<br>
residing. So I cannot say anything from what you showed below...<br>
<div class="HOEnZb"><div class="h5">--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
> I see it in log for example:<br>
><br>
> On master db:<br>
> in i see this /var/log/postgresql/postgresql-9.1-main.log<br>
> 2012-05-21 15:02:21 MSK @ šLOG: šreceived fast shutdown request<br>
> 2012-05-21 15:02:21 MSK @ šLOG: šaborting any active transactions<br>
><br>
> in /var/log/auth.log i see this:<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: PAM: initializing for "postgres"<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: PAM: setting PAM_RHOST to<br>
> "dbbalancer1"<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: PAM: setting PAM_TTY to "ssh"<br>
> May 21 15:02:21 pre-db2 sshd[6805]: Failed none for postgres from<br>
> 10.2.141.51 port 33031 ssh2<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: Checking blacklist file<br>
> /usr/share/ssh/blacklist.RSA-2048<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: Checking blacklist file<br>
> /etc/ssh/blacklist.RSA-2048<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: temporarily_use_uid: 105/109<br>
> (e=0/0)<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: trying public key file<br>
> /var/lib/postgresql/.ssh/authorized_keys<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: fd 4 clearing O_NONBLOCK<br>
> May 21 15:02:21 pre-db2 sshd[6805]: debug1: matching key found: file<br>
> /var/lib/postgresql/.ssh/authorized_keys, line 2<br>
><br>
> I run pgpool on host dbbalancer1 under user postgres. šAnd configure pgpool<br>
> script work under postgres and used ssh keys.<br>
><br>
> And this situation repeated twice.<br>
><br>
><br>
><br>
><br>
><br>
><br>
> 2012/5/21 Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>><br>
><br>
>> > I have pgpool-II version 3.1.3 installed and three db postgresql 9.1.3 in<br>
>> > streaming replication. When i try to drop database i see this in pgpool<br>
>> log:<br>
>> ><br>
>> > 2012-05-21 15:01:48 LOG: š pid 15484: pool_send_and_wait: Error or notice<br>
>> > message from backend: : DB node id: 1 backend pid: 6769 statement: DROP<br>
>> > DATABASE xxx; message: database "xxx" is being accessed by other users<br>
>> > 2012-05-21 15:02:20 LOG: š pid 26326: postmaster on DB node 1 was<br>
>> shutdown<br>
>> > by administrative command<br>
>> > 2012-05-21 15:02:20 LOG: š pid 26326: degenerate_backend_set: 1 fail over<br>
>> > request from pid 26326<br>
>> > 2012-05-21 15:02:20 LOG: š pid 4975: starting degeneration. shutdown host<br>
>> > 10.141.2.54(5432)<br>
>> > 2012-05-21 15:02:20 LOG: š pid 4975: Restart all children<br>
>> > 2012-05-21 15:02:20 LOG: š pid 4975: execute command:<br>
>> > /etc/pgpool.d/failover.sh 1 10.141.2.54 5432<br>
>> /var/lib/postgresql/9.1/main 0<br>
>> > 10.141.2.53 0 1<br>
>> > 2012-05-21_15:02:20 failover: Master failed at 10.141.2.54 (0). New<br>
>> master<br>
>> > is 10.141.2.53 (0)<br>
>> > 2012-05-21_15:02:20 failover: New master start triggered.<br>
>> ><br>
>> > Why pgpool initiated failover procedure on statement drop database? I add<br>
>> > drop statement in black_function_list may be this helps me.<br>
>><br>
>> Why do you think drop database initiated failover? The failover<br>
>> happend 32 seconds after drop database error.<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>><br>
><br>
><br>
><br>
> --<br>
> ó Õ×ÁÖÅÎÉÅÍ óÅÌÑ×ËÁ å×ÇÅÎÉÊ<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>ó Õ×ÁÖÅÎÉÅÍ óÅÌÑ×ËÁ å×ÇÅÎÉÊ<br>