[Pgpool-general] General Errors trying to run pgpool 2.1

Duncan McQueen dwmcqueen at gmail.com
Tue Jul 29 02:28:57 UTC 2008 

I am having issues connecting to pgpool running on a server set-up
with a node on it.  I get this message whenever trying to connect:

psql: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.


My debug log is as follows:
2008-07-28 21:24:36 DEBUG: pid 8142: key: listen_addresses
2008-07-28 21:24:36 DEBUG: pid 8142: value: 'localhost' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: port
2008-07-28 21:24:36 DEBUG: pid 8142: value: 5433 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: pcp_port
2008-07-28 21:24:36 DEBUG: pid 8142: value: 9898 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: socket_dir
2008-07-28 21:24:36 DEBUG: pid 8142: value: '/var/run/postgresql' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: pcp_socket_dir
2008-07-28 21:24:36 DEBUG: pid 8142: value: '/var/run/postgresql' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: backend_socket_dir
2008-07-28 21:24:36 DEBUG: pid 8142: value: '/var/run/postgresql' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: pcp_timeout
2008-07-28 21:24:36 DEBUG: pid 8142: value: 10 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: num_init_children
2008-07-28 21:24:36 DEBUG: pid 8142: value: 32 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: max_pool
2008-07-28 21:24:36 DEBUG: pid 8142: value: 4 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: child_life_time
2008-07-28 21:24:36 DEBUG: pid 8142: value: 300 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: connection_life_time
2008-07-28 21:24:36 DEBUG: pid 8142: value: 0 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: child_max_connections
2008-07-28 21:24:36 DEBUG: pid 8142: value: 0 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: authentication_timeout
2008-07-28 21:24:36 DEBUG: pid 8142: value: 60 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: logdir
2008-07-28 21:24:36 DEBUG: pid 8142: value: '/var/run/postgresql' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: replication_mode
2008-07-28 21:24:36 DEBUG: pid 8142: value: true kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: replication_strict
2008-07-28 21:24:36 DEBUG: pid 8142: value: true kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: replication_timeout
2008-07-28 21:24:36 DEBUG: pid 8142: value: 5000 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: load_balance_mode
2008-07-28 21:24:36 DEBUG: pid 8142: value: true kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: replication_stop_on_mismatch
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: replication_stop_on_mismatch: 0
2008-07-28 21:24:36 DEBUG: pid 8142: key: replicate_select
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: replicate_select: 0
2008-07-28 21:24:36 DEBUG: pid 8142: key: reset_query_list
2008-07-28 21:24:36 DEBUG: pid 8142: value: 'ABORT; RESET ALL; SET SESSION AUTHO
RIZATION DEFAULT' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: extract_string_tokens: token: ABORT
2008-07-28 21:24:36 DEBUG: pid 8142: extract_string_tokens: token:  RESET ALL
2008-07-28 21:24:36 DEBUG: pid 8142: extract_string_tokens: token:  SET SESSION
AUTHORIZATION DEFAULT
2008-07-28 21:24:36 DEBUG: pid 8142: key: print_timestamp
2008-07-28 21:24:36 DEBUG: pid 8142: value: true kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: master_slave_mode
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: connection_cache
2008-07-28 21:24:36 DEBUG: pid 8142: value: true kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: health_check_timeout
2008-07-28 21:24:36 DEBUG: pid 8142: value: 20 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: health_check_period
2008-07-28 21:24:36 DEBUG: pid 8142: value: 0 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: health_check_user
2008-07-28 21:24:36 DEBUG: pid 8142: value: 'nobody' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: insert_lock
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: ignore_leading_white_space
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: log_statement
2008-07-28 21:24:36 DEBUG: pid 8142: value: true kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: log_connections
2008-07-28 21:24:36 DEBUG: pid 8142: value: true kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: log_hostname
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: parallel_mode
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: enable_query_cache
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: key: pgpool2_hostname
2008-07-28 21:24:36 DEBUG: pid 8142: value: '' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: system_db_hostname
2008-07-28 21:24:36 DEBUG: pid 8142: value: 'localhost' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: system_db_port
2008-07-28 21:24:36 DEBUG: pid 8142: value: 5432 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: key: system_db_dbname
2008-07-28 21:24:36 DEBUG: pid 8142: value: 'pgpool' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: system_db_schema
2008-07-28 21:24:36 DEBUG: pid 8142: value: 'pgpool_catalog' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: system_db_user
2008-07-28 21:24:36 DEBUG: pid 8142: value: 'pgpool' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: system_db_password
2008-07-28 21:24:36 DEBUG: pid 8142: value: '' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: backend_hostname0
2008-07-28 21:24:36 DEBUG: pid 8142: value: 'localhost' kind: 4
2008-07-28 21:24:36 DEBUG: pid 8142: key: backend_port0
2008-07-28 21:24:36 DEBUG: pid 8142: value: 5432 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: pool_config: port slot number 0
2008-07-28 21:24:36 DEBUG: pid 8142: key: backend_weight0
2008-07-28 21:24:36 DEBUG: pid 8142: value: 1 kind: 2
2008-07-28 21:24:36 DEBUG: pid 8142: pool_config: weight slot number 0 weight: 1
.000000
2008-07-28 21:24:36 DEBUG: pid 8142: key: enable_pool_hba
2008-07-28 21:24:36 DEBUG: pid 8142: value: false kind: 1
2008-07-28 21:24:36 DEBUG: pid 8142: num_backends: 1 num_backends: 1 total_weigh
t: 1.000000
2008-07-28 21:24:36 DEBUG: pid 8142: backend 0 weight: 2147483647.000000
2008-07-28 21:24:36 DEBUG: pid 8143: I am 8143
2008-07-28 21:24:36 DEBUG: pid 8144: I am 8144
2008-07-28 21:24:36 DEBUG: pid 8145: I am 8145
2008-07-28 21:24:36 DEBUG: pid 8148: I am 8148
2008-07-28 21:24:36 DEBUG: pid 8149: I am 8149
2008-07-28 21:24:36 DEBUG: pid 8150: I am 8150
2008-07-28 21:24:36 DEBUG: pid 8151: I am 8151
2008-07-28 21:24:36 DEBUG: pid 8152: I am 8152
2008-07-28 21:24:36 DEBUG: pid 8153: I am 8153
2008-07-28 21:24:36 DEBUG: pid 8154: I am 8154
2008-07-28 21:24:36 DEBUG: pid 8155: I am 8155
2008-07-28 21:24:36 DEBUG: pid 8156: I am 8156
2008-07-28 21:24:36 DEBUG: pid 8157: I am 8157
2008-07-28 21:24:36 DEBUG: pid 8158: I am 8158
2008-07-28 21:24:36 DEBUG: pid 8159: I am 8159
2008-07-28 21:24:36 DEBUG: pid 8160: I am 8160
2008-07-28 21:24:36 DEBUG: pid 8161: I am 8161
2008-07-28 21:24:36 DEBUG: pid 8162: I am 8162
2008-07-28 21:24:36 DEBUG: pid 8163: I am 8163
2008-07-28 21:24:36 DEBUG: pid 8164: I am 8164
2008-07-28 21:24:36 DEBUG: pid 8165: I am 8165
2008-07-28 21:24:36 DEBUG: pid 8166: I am 8166
2008-07-28 21:24:36 DEBUG: pid 8167: I am 8167
2008-07-28 21:24:36 DEBUG: pid 8168: I am 8168
2008-07-28 21:24:36 DEBUG: pid 8169: I am 8169
2008-07-28 21:24:36 DEBUG: pid 8170: I am 8170
2008-07-28 21:24:36 DEBUG: pid 8171: I am 8171
2008-07-28 21:24:36 DEBUG: pid 8172: I am 8172
2008-07-28 21:24:36 DEBUG: pid 8173: I am 8173
2008-07-28 21:24:36 DEBUG: pid 8174: I am 8174
2008-07-28 21:24:36 DEBUG: pid 8175: I am 8175
2008-07-28 21:24:36 DEBUG: pid 8176: I am 8176
2008-07-28 21:24:36 LOG:   pid 8142: pgpool successfully started
2008-07-28 21:24:36 DEBUG: pid 8177: I am PCP 8177
2008-07-28 21:24:42 DEBUG: pid 8176: I am 8176 accept fd 0
2008-07-28 21:24:42 LOG:   pid 8176: connection received: host=[local]
2008-07-28 21:24:42 DEBUG: pid 8176: Protocol Major: 3 Minor: 0 database: root u
ser: root
2008-07-28 21:24:42 DEBUG: pid 8176: new_connection: connecting 0 backend
2008-07-28 21:24:42 LOG:   pid 8176: pool_do_auth: maybe protocol version mismat
ch (current version 3)
2008-07-28 21:24:42 DEBUG: pid 8176: pool_read_string: read all from pending dat
a. po:1 len:122
2008-07-28 21:25:12 DEBUG: pid 8176: I am 8176 accept fd 0
2008-07-28 21:25:12 LOG:   pid 8176: connection received: host=[local]
2008-07-28 21:25:12 DEBUG: pid 8176: Protocol Major: 3 Minor: 0 database: postgr
es user: postgres
2008-07-28 21:25:12 DEBUG: pid 8176: new_connection: connecting 0 backend
2008-07-28 21:25:12 LOG:   pid 8176: pool_do_auth: maybe protocol version mismat
ch (current version 3)
2008-07-28 21:25:12 DEBUG: pid 8176: pool_read_string: read all from pending dat
a. po:1 len:122


My key question is - how should the pg_hba.conf be in the pgpool, and
on the postgres node?  Should I create a user on the node?  Any
examples to get this work?

Thanks,

Duncan

More information about the Pgpool-general mailing list