Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B86A9632C27 for ; Thu, 26 Feb 2009 16:02:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83191-09 for ; Thu, 26 Feb 2009 16:02:04 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.174]) by mail.postgresql.org (Postfix) with ESMTP id B8EC9632A33 for ; Thu, 26 Feb 2009 16:02:04 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 23so772972wfg.28 for ; Thu, 26 Feb 2009 12:02:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=E0YHW4mwMxfE7wMnFVj6oDvhFNZnWFTlGcfldQudgwU=; b=QpoRmB86R60qeo7YJdg6XQC1S8t4FgZRgZOCc8khFEmXmiSdP6xCCe+/qxMzVl4YRY ZurpS94vZdIFMcmLocnV7AW6QVdxc5hoLN8fnDlUlxgOxqfH1w8v7KkbURVlZfo/sXJR 6slSKTGHguj6v8kHBS7srSahTsDZhk2R15ago= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=xefB0DzoNh3xOQXaZJ+WXjeiPSuPXUDRxXSVPNIqeTAU7bj6PberMp4WQXH8VcogWf SF4YvcynSKNa8rZj9rnioFA9ws1/9d24rZ1SHbj5jlbZ3ub5Qn+bDe4KiwPxD/Eo0fpe zXEEi+LMG315qY4PO0FVIghdLDM0Jsf7DdTNw= MIME-Version: 1.0 Received: by 10.142.185.21 with SMTP id i21mr813041wff.311.1235678523029; Thu, 26 Feb 2009 12:02:03 -0800 (PST) Date: Thu, 26 Feb 2009 12:02:03 -0800 Message-ID: Subject: Pgpool Issue- From: DM To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd215b86bf9540463d7d362 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200902/249 X-Sequence-Number: 31470 --000e0cd215b86bf9540463d7d362 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi All, I have installed Postgres 8.3.3 and Pgpool 2.2RC2 on two machines and* Both *servers have the identical copy of the database running. I have started postgres server on both machines and I have started pgpool on both machines. But for some reasons i am not able to connect to database through pgpool. psql -U postgres -p 9999 *Pgpool logs for the first machine shows* 2009-02-25 18:00:31 LOG: pid 30544: pgpool successfully started 2009-02-25 18:04:27 LOG: pid 30555: connection received: host=[local] 2009-02-25 18:04:27 ERROR: pid 30555: pool_read_kind: kind does not match between master(82) slot[1] (69) 2009-02-26 10:56:19 ERROR: pid 30544: connect_inet_domain_socket: connect() failed: Connection refused 2009-02-26 10:56:19 ERROR: pid 30544: health check failed. 1 th host fdbr-res0002 at port 5432 is down 2009-02-26 10:56:19 LOG: pid 30544: set 1 th backend down status 2009-02-26 10:56:19 LOG: pid 30544: starting degeneration. shutdown host fdbr-res0002(5432) 2009-02-26 10:56:19 LOG: pid 30544: failover_handler: set new master node: 0 2009-02-26 10:56:19 LOG: pid 30544: failover done. shutdown host fdbr-res0002(5432) pid file found. is another pgpool(30544) is running? 2009-02-26 10:58:03 ERROR: pid 30544: connect_inet_domain_socket: connect() failed: Connection refused 2009-02-26 10:58:03 ERROR: pid 30544: health check failed. 0 th host localhost at port 5432 is down 2009-02-26 10:58:03 LOG: pid 30544: set 0 th backend down status 2009-02-26 10:58:03 LOG: pid 30544: starting degeneration. shutdown host localhost(5432) 2009-02-26 10:58:03 ERROR: pid 30544: failover_handler: no valid DB node found 2009-02-26 10:58:03 LOG: pid 30544: failover_handler: set new master node: 2 2009-02-26 10:58:03 LOG: pid 30544: failover done. shutdown host localhost(5432) pid file found. is another pgpool(30544) is running? 2009-02-26 11:44:11 LOG: pid 7900: Cannot accept() new connection. all backends are down 2009-02-26 11:45:59 LOG: pid 21707: Cannot accept() new connection. all backends are down 2009-02-26 11:46:25 LOG: pid 30544: received fast shutdown request stop request sent to pgpool. waiting for termination....done. I can connect to individual database using "psql -U postgres -p 5432" --> fdbr-res0001 "psql -U postgres -p 5432" --> fdbr-res0002 Here is the configuration of Pgpool.conf file, both machines have the same identical configuration file with only backend_hostname1 = 'fdbr-res0002' difference listen_addresses = '*' port = 9999 pcp_port = 9898 socket_dir = '/tmp' pcp_socket_dir = '/tmp' backend_socket_dir = '/tmp' pcp_timeout = 10 num_init_children = 64 max_pool = 10 child_life_time = 300 connection_life_time = 0 child_max_connections = 0 client_idle_limit = 0 authentication_timeout = 60 logdir = '/usr/pgpool-II/2.2RC2/log' pid_file_name = '/usr/pgpool-II/2.2RC2/etc/pgpool.pid' replication_mode = true load_balance_mode = true replication_stop_on_mismatch = false replicate_select = false reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' print_timestamp = true master_slave_mode = false connection_cache = true health_check_timeout = 20 health_check_period = 1 health_check_user = 'postgres' failover_command = '' failback_command = '' insert_lock = false ignore_leading_white_space = true log_statement = true log_connections = true log_hostname = true parallel_mode = false enable_query_cache = false #pgpool2_hostname = 'fdbr-res0002' pgpool2_hostname = '' system_db_hostname = 'localhost' system_db_port = 5432 system_db_dbname = 'pgpool' system_db_schema = 'pgpool_catalog' system_db_user = 'pgpool' system_db_password = '' backend_hostname0 = 'localhost' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/mnt/data/pns/pgsql8.3.6' backend_hostname1 = 'fdbr-res0002' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '/mnt/data/pns/pgsql8.3.6' enable_pool_hba = true recovery_user = 'postgres' recovery_password = '' recovery_1st_stage_command = '' recovery_2nd_stage_command = '' recovery_timeout = 90 client_idle_limit_in_recovery = 0 Any solution would be greatly appreciated Thanks Deepak Murthy --000e0cd215b86bf9540463d7d362 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi All,

I have installed Postgres 8.3.3 and Pgpool 2.2RC2 on two mac= hines and Both servers have the identical copy of the database runni= ng.
I have started postgres server on both machines and I have started = pgpool on both machines.

But for some reasons i am not able to connect to database through pgpoo= l.
psql -U postgres -p 9999

Pgpool logs for the first machine = shows

2009-02-25 18:00:31 LOG:=A0=A0 pid 30544: pgpool successfu= lly started
2009-02-25 18:04:27 LOG:=A0=A0 pid 30555: connection received: host=3D[loca= l]
2009-02-25 18:04:27 ERROR: pid 30555: pool_read_kind: kind does not m= atch between master(82) slot[1] (69)
2009-02-26 10:56:19 ERROR: pid 3054= 4: connect_inet_domain_socket: connect() failed: Connection refused
2009-02-26 10:56:19 ERROR: pid 30544: health check failed. 1 th host fdbr-r= es0002 at port 5432 is down
2009-02-26 10:56:19 LOG:=A0=A0 pid 30544: se= t 1 th backend down status
2009-02-26 10:56:19 LOG:=A0=A0 pid 30544: sta= rting degeneration. shutdown host fdbr-res0002(5432)
2009-02-26 10:56:19 LOG:=A0=A0 pid 30544: failover_handler: set new master = node: 0
2009-02-26 10:56:19 LOG:=A0=A0 pid 30544: failover done. shutdow= n host fdbr-res0002(5432)
pid file found. is another pgpool(30544) is ru= nning?
2009-02-26 10:58:03 ERROR: pid 30544: connect_inet_domain_socket: connect()= failed: Connection refused
2009-02-26 10:58:03 ERROR: pid 30544: health= check failed. 0 th host localhost at port 5432 is down
2009-02-26 10:58= :03 LOG:=A0=A0 pid 30544: set 0 th backend down status
2009-02-26 10:58:03 LOG:=A0=A0 pid 30544: starting degeneration. shutdown h= ost localhost(5432)
2009-02-26 10:58:03 ERROR: pid 30544: failover_handl= er: no valid DB node found
2009-02-26 10:58:03 LOG:=A0=A0 pid 30544: fai= lover_handler: set new master node: 2
2009-02-26 10:58:03 LOG:=A0=A0 pid 30544: failover done. shutdown host loca= lhost(5432)
pid file found. is another pgpool(30544) is running?
2009= -02-26 11:44:11 LOG:=A0=A0 pid 7900: Cannot accept() new connection. all ba= ckends are down
2009-02-26 11:45:59 LOG:=A0=A0 pid 21707: Cannot accept() new connection. a= ll backends are down
2009-02-26 11:46:25 LOG:=A0=A0 pid 30544: received = fast shutdown request
stop request sent to pgpool. waiting for terminati= on....done.


I can connect to individual database using
"psql -U postgr= es -p 5432" --> fdbr-res0001
"psql -U postgres -p 5432"= ; --> fdbr-res0002

Here is the configuration of Pgpool.conf file,= both machines have the same identical configuration file with only backend= _hostname1 =3D 'fdbr-res0002' difference

listen_addresses =3D '*'
port =3D 9999
pcp_port =3D 9898<= br>socket_dir =3D '/tmp'
pcp_socket_dir =3D '/tmp'
ba= ckend_socket_dir =3D '/tmp'
pcp_timeout =3D 10
num_init_child= ren =3D 64
max_pool =3D 10
child_life_time =3D 300
connection_life_time =3D 0child_max_connections =3D 0
client_idle_limit =3D 0
authentication_t= imeout =3D 60
logdir =3D '/usr/pgpool-II/2.2RC2/log'
pid_file= _name =3D '/usr/pgpool-II/2.2RC2/etc/pgpool.pid'
replication_mode =3D true
load_balance_mode =3D true
replication_stop= _on_mismatch =3D false
replicate_select =3D false
reset_query_list = =3D 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
print_= timestamp =3D true
master_slave_mode =3D false
connection_cache =3D true
health_check_ti= meout =3D 20
health_check_period =3D 1
health_check_user =3D 'pos= tgres'
failover_command =3D ''
failback_command =3D '= '
insert_lock =3D false
ignore_leading_white_space =3D true
log_statement =3D true
log_conne= ctions =3D true
log_hostname =3D true
parallel_mode =3D false
en= able_query_cache =3D false
#pgpool2_hostname =3D 'fdbr-res0002'<= br>pgpool2_hostname =3D ''
system_db_hostname =3D 'localhost'
system_db_port =3D 5432
sy= stem_db_dbname =3D 'pgpool'
system_db_schema =3D 'pgpool_cat= alog'
system_db_user =3D 'pgpool'
system_db_password =3D = ''

backend_hostname0 =3D 'localhost'
backend_port0 =3D 5432
= backend_weight0 =3D 1
backend_data_directory0 =3D '/mnt/data/pns/pgs= ql8.3.6'

backend_hostname1 =3D 'fdbr-res0002'
backend= _port1 =3D 5432
backend_weight1 =3D 1
backend_data_directory1 =3D '/mnt/data/pns/pgs= ql8.3.6'

enable_pool_hba =3D true
recovery_user =3D 'post= gres'
recovery_password =3D ''
recovery_1st_stage_command= =3D ''
recovery_2nd_stage_command =3D ''
recovery_timeout =3D 90
cli= ent_idle_limit_in_recovery =3D 0


Any solution would be greatly a= ppreciated

Thanks
Deepak Murthy

--000e0cd215b86bf9540463d7d362--