What versions are your PostgreSQL servers? Maybe 8.3? Do your PostgreSQL servers use GSSAPI authentication? I'm afraid pgpool-II does not support it (yet). -- Tatsuo Ishii SRA OSS, Inc. Japan
> Greetings all! > > I have a problem with pgpool-ii-1.3. Debug information is below... > ..... > 2007-10-25 16:28:20 DEBUG: pid 29850: loading "/usr/local/etc/pool_hba.conf" > for client authentication configuration file > 2007-10-25 16:28:20 DEBUG: pid 29851: I am 29851 > 2007-10-25 16:28:20 DEBUG: pid 29852: I am 29852 > 2007-10-25 16:28:20 DEBUG: pid 29853: I am 29853 > 2007-10-25 16:28:20 DEBUG: pid 29854: I am 29854 > 2007-10-25 16:28:20 DEBUG: pid 29855: I am 29855 > 2007-10-25 16:28:20 DEBUG: pid 29856: I am 29856 > 2007-10-25 16:28:20 DEBUG: pid 29858: I am 29858 > 2007-10-25 16:28:20 DEBUG: pid 29859: I am 29859 > 2007-10-25 16:28:20 DEBUG: pid 29860: I am 29860 > 2007-10-25 16:28:20 DEBUG: pid 29861: I am 29861 > 2007-10-25 16:28:20 DEBUG: pid 29857: I am 29857 > 2007-10-25 16:28:20 DEBUG: pid 29862: I am 29862 > 2007-10-25 16:28:20 LOG: pid 29850: pgpool successfully started > 2007-10-25 16:28:20 DEBUG: pid 29863: I am PCP 29863 > 2007-10-25 16:28:55 DEBUG: pid 29857: I am 29857 accept fd 0 > 2007-10-25 16:28:55 LOG: pid 29857: connection received: host= > replica.test.box.ru port=50558 > 2007-10-25 16:28:55 DEBUG: pid 29857: Protocol Major: 3 Minor: 0 database: > testdb user: tester > 2007-10-25 16:28:55 DEBUG: pid 29857: new_connection: connecting 0 backend > 2007-10-25 16:28:55 DEBUG: pid 29857: new_connection: connecting 1 backend > 2007-10-25 16:28:55 DEBUG: pid 29857: pool_read_message_length: slot: 0 > length: 8 > 2007-10-25 16:28:55 DEBUG: pid 29857: pool_read_message_length: slot: 1 > length: 8 > 2007-10-25 16:28:55 ERROR: pid 29857: pool_read_int: data does not match > between between master(0) slot[1] (50331648) > 2007-10-25 16:28:55 ERROR: pid 29857: pool_do_auth: read pid failed > 2007-10-25 16:29:41 DEBUG: pid 29857: I am 29857 accept fd 0 > 2007-10-25 16:29:41 LOG: pid 29857: connection received: host= > replica.test.box.ru port=45897 > 2007-10-25 16:29:41 DEBUG: pid 29857: Protocol Major: 3 Minor: 0 database: > testdb user: tester > 2007-10-25 16:29:41 DEBUG: pid 29857: new_connection: connecting 0 backend > 2007-10-25 16:29:41 DEBUG: pid 29857: new_connection: connecting 1 backend > 2007-10-25 16:29:41 DEBUG: pid 29857: pool_read_message_length: slot: 0 > length: 8 > 2007-10-25 16:29:41 DEBUG: pid 29857: pool_read_message_length: slot: 1 > length: 8 > 2007-10-25 16:29:41 ERROR: pid 29857: pool_read_int: data does not match > between between master(0) slot[1] (50331648) > 2007-10-25 16:29:41 ERROR: pid 29857: pool_do_auth: read pid failed > > I wish to deploy master-slave configuration with two backends (replication > with Slony-I). Pgpool-ii works on the backend0 ( master ). > Here is my configuration file: > > listen_addresses = '*' > port = 9999 > pcp_port = 9898 > socket_dir = '/tmp' > pcp_socket_dir = '/tmp' > backend_socket_dir = '/tmp' > pcp_timeout = 10 > num_init_children = 12 > max_pool = 1 > child_life_time = 300 > connection_life_time = 0 > child_max_connections = 0 > authentication_timeout = 60 > > # logging > logdir = '/var/log' > print_timestamp = true > log_statement = true > log_connections = true > log_hostname = true > # End of logging > > # Work mode > parallel_mode = false > replication_mode = false > load_balance_mode = true > master_slave_mode = true > # End of the work mode > > reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' > connection_cache = true > health_check_timeout = 20 > health_check_period = 0 > health_check_user = 'nobody' > insert_lock = false > ignore_leading_white_space = false > enable_query_cache = false > pgpool2_hostname = 'replica.test.box.ru' > backend_hostname0 = 'replica.test.box.ru' > backend_port0 = 5432 > backend_weight0 = 1 > backend_hostname1 = 'replica1.test.box.ru' > backend_port1 = 5432 > backend_weight1 = 1 > enable_pool_hba = true > > > [EMAIL PROTECTED]:~/bin$ ./psql -U tester -d testdb -W -p 9999 -h > 192.168.157.120 > Password for user tester: > psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > In the debug information I got ERROR: pid 29857: pool_read_int: data does > not match between between master(0) slot[1] (50331648). > Any ideas? > Thank you in advance. > > > -- > best regards, > Oleg Laktionov _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
