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

[Tatsuo Ishii]

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 <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