This one: > 2011-01-17 15:16:29 ERROR: pid 10323: pool_read2: failed to realloc is definitely no good. Can you show me self contained test case? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> Were you able to get away with those error messages of s_do_auth? I see the > same > messages in my log as well. Please do let me know how did you fix it? > > > > > ________________________________ > From: George Baker <[email protected]> > To: [email protected] > Sent: Tue, January 18, 2011 2:02:49 AM > Subject: [Pgpool-general] Internal Postgres 9.0 hot_standby and pgpool II > setup > > I have set up the Postgresql 9.0 hot_standby replication and so far it works > very well. I'm now trying to set up pgpool II balance > > > 2011-01-17 15:16:29 ERROR: pid 10323: pool_read2: failed to realloc > 2011-01-17 15:16:29 DEBUG: pid 9774: reap_handler called > 2011-01-17 15:16:29 DEBUG: pid 9774: reap_handler: call wait3 > 2011-01-17 15:16:29 LOG: pid 9774: worker child 10323 exits with status 256 > 2011-01-17 15:16:29 DEBUG: pid 10356: I am 10356 > 2011-01-17 15:16:29 LOG: pid 9774: fork a new worker child pid 10356 > 2011-01-17 15:16:29 DEBUG: pid 9774: reap_handler: normally exited > 2011-01-17 15:16:59 DEBUG: pid 10356: pool_ssl: SSL requested but SSL support > is > not available > 2011-01-17 15:16:59 DEBUG: pid 10356: s_do_auth: auth kind: 0 > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "E" before > processing BackendKeyData > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "" before > processing BackendKeyData > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "" before > processing BackendKeyData > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "" before > processing BackendKeyData > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "[" before > processing BackendKeyData > 2011-01-17 15:16:59 DEBUG: pid 10356: s_do_auth: parameter status data > received > 2011-01-17 15:16:59 ERROR: pid 10356: pool_read2: EOF encountered with backend > 2011-01-17 15:16:59 ERROR: pid 10356: make_persistent_db_connection: s_do_auth > failed > 2011-01-17 15:16:59 DEBUG: pid 10356: pool_ssl: SSL requested but SSL support > is > not available > 2011-01-17 15:16:59 DEBUG: pid 10356: s_do_auth: auth kind: 0 > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "E" before > processing BackendKeyData > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "" before > processing BackendKeyData > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "" before > processing BackendKeyData > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "" before > processing BackendKeyData > 2011-01-17 15:16:59 ERROR: pid 10356: s_do_auth: unknown response "[" before > processing BackendKeyData > 2011-01-17 15:16:59 DEBUG: pid 10356: s_do_auth: parameter status data > received > 2011-01-17 15:16:59 ERROR: pid 10356: pool_read2: EOF encountered with backend > 2011-01-17 15:16:59 ERROR: pid 10356: make_persistent_db_connection: s_do_auth > failed > 2011-01-17 15:16:59 ERROR: pid 10356: check_replication_time_lag: DB node is > valid but no persistent connection > > > I've got ssl = false in the pgpool.conf file. I've also commented out all > other > ssl parameters. This just keeps happening over and over. Is there a sample > config file for pgpool that just does the balancing, and lets postgresql do > its > own replication? > > Thanks > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
