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 "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 10.2.141.51 port 33031 ssh2<br>May 21 15:02:21 pre-db2 sshd[6805]: debug1: Checking blacklist file /usr/share/ssh/blacklist.RSA-2048<br>
May 21 15:02:21 pre-db2 sshd[6805]: debug1: Checking blacklist file /etc/ssh/blacklist.RSA-2048<br>May 21 15:02:21 pre-db2 sshd[6805]: debug1: temporarily_use_uid: 105/109 (e=0/0)<br>May 21 15:02:21 pre-db2 sshd[6805]: debug1: trying public key file /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 /var/lib/postgresql/.ssh/authorized_keys, line 2<br><br>I run pgpool on host dbbalancer1 under user postgres.š And configure pgpool script work under postgres and used ssh keys.<br>
<br>And this situation <span id="result_box" class="short_text" lang="en"><span class="hps">repeated</span></span> twice. <br><br><br><br><br><br><br><div class="gmail_quote">2012/5/21 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"><div class="HOEnZb"><div class="h5">> 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 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 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 /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 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>
</div></div>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>
</blockquote></div><br><br clear="all"><br>-- <br>ó Õ×ÁÖÅÎÉÅÍ óÅÌÑ×ËÁ å×ÇÅÎÉÊ<br>