Tatsuo Ishii <ishii@...> writes: > > After recovering old primary(5432) can you connect to pgpool without > problem? Then this is normal. Pgpool needs to restart all child > process after recovery. > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > > > Alright. Once the failover is done successfully and the standby is promoted to > > new primary, I start the recovery of the old primary (5432). > > > > The ol primary is getting recovered. But I found that pgpool is getting killed. > > Why? Here is the pgpool log: > > ...... > > 2011-04-19 11:23:42 LOG: pid 15894: send_failback_request: fail back 0 th node > > request from pid 15894 > > 2011-04-19 11:23:42 DEBUG: pid 21977: s_do_auth: auth kind: 0 > > 2011-04-19 11:23:42 ERROR: pid 21977: s_do_auth: unknown response "E" > > before > > processing BackendKeyData > > 2011-04-19 11:23:42 ERROR: pid 21977: s_do_auth: unknown response "^@" before > > processing BackendKeyData > > 2011-04-19 11:23:42 ERROR: pid 21977: s_do_auth: unknown response "^@" before > > processing BackendKeyData > > 2011-04-19 11:23:42 ERROR: pid 21977: s_do_auth: unknown response "^@" before > > processing BackendKeyData > > 2011-04-19 11:23:42 ERROR: pid 21977: s_do_auth: unknown response "V" > > before > > processing BackendKeyData > > 2011-04-19 11:23:42 DEBUG: pid 21977: s_do_auth: parameter status data received > > 2011-04-19 11:23:42 ERROR: pid 21977: pool_read2: failed to realloc > > 2011-04-19 11:23:42 DEBUG: pid 15861: failover_handler called > > 2011-04-19 11:23:42 DEBUG: pid 15861: failover_handler: starting to select new
Im having this issue as well. postgres 9.0 with streaming replication setup. pgpool pgpool2_3.0.4-1_i386.deb on ubuntu 10.04 when I just have pgpool pushing to one backend it works. when I turn on load balanceing, master/slave and set master_slave_sub_mode to 'stream' . if I have these turned off it works fine. I've got ssl disabled in pgpool and the two dbs and authentication set to trust. hope this helps _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
