[Pgpool-general] Internal Postgres 9.0 hot_standby and pgpool II setup

[Sandeep Thakkar]

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 <george.baker at dhs-club.com>
To: pgpool-general at pgfoundry.org
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
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110418/013693a6/attachment.html>