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

[George Baker]

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