X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 02F9356754 for ; Mon, 21 Mar 2005 06:25:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68044-06 for ; Mon, 21 Mar 2005 06:24:53 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 420C35526B for ; Mon, 21 Mar 2005 06:24:52 +0000 (GMT) Received: (qmail 4671 invoked from network); 21 Mar 2005 06:24:52 -0000 Received: from host-209.149.56.238.nashville.net (HELO ?10.0.1.2?) (209.149.56.238) by 0 with SMTP; 21 Mar 2005 06:24:52 -0000 In-Reply-To: <3FABB7B119FDE24AB2425A7FB5EE4BC22E996E@exags01.inegi.gob.mx> References: <3FABB7B119FDE24AB2425A7FB5EE4BC22E996E@exags01.inegi.gob.mx> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=WINDOWS-1252; format=flowed Message-Id: <182ab310f870f70f7fc1cb3f293010a6@sitening.com> Content-Transfer-Encoding: quoted-printable Cc: From: Thomas F.O'Connell Subject: Re: testing pgpool Date: Mon, 21 Mar 2005 00:24:52 -0600 To: "ESPARZA JUAREZ EDUARDO" X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/323 X-Sequence-Number: 16821 Is postgres actually running? And is your pg_hba.conf file configured=20 to allow local UNIX socket connections? -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 16, 2005, at 10:50 AM, ESPARZA JUAREZ EDUARDO wrote: > Hi list!! > > =A0 > > I tested pgpool with pgpool.conf as follows: > > =A0 > > listen_addresses =3D 'localhost' > > port =3D 9999 > > socket_dir =3D '/tmp' > > backend_host_name =3D '' > > backend_port =3D 5432 > > backend_socket_dir =3D '/tmp' > > secondary_backend_host_name =3D '' > > secondary_backend_port =3D 0 > > num_init_children =3D 15 > > max_pool =3D 10 > > child_life_time =3D 300 > > connection_life_time =3D 0 > > logdir =3D '/tmp' > > replication_mode =3D false > > replication_strict =3D true > > replication_timeout =3D 5000 > > load_balance_mode =3D false > > weight_master =3D 0.5 > > weight_secondary =3D 0.5 > > replication_stop_on_mismatch =3D false > > reset_query_list =3D 'ABORT; RESET ALL; SET SESSION AUTHORIZATION=20 > DEFAULT' > > print_timestamp =3D true > > master_slave_mode =3D false > > connection_cache =3D true > > health_check_timeout =3D 20 > > health_check_period =3D 0 > > health_check_user =3D 'nobody' > > =A0 > but when I try get internal status of pgpool (psql -p 9999 -c 'show=20 > pool_status' template1) I get: > =A0 > psql: could not connect to server: =B8W@$g@=B9#@x=F6=FF=BFQ > Is the server running locally and accepting > =A0=A0=A0=A0=A0=A0=A0 connections on Unix domain socket = "/tmp/.s.PGSQL.9999"? > =A0 > Thank=92s > Eej-