X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 59540D1C4C3 for ; Fri, 21 May 2004 20:51:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 85137-06 for ; Fri, 21 May 2004 20:50:54 -0300 (ADT) Received: from lakermmtao12.cox.net (lakermmtao12.cox.net [68.230.240.27]) by svr1.postgresql.org (Postfix) with ESMTP id 741C9D1B16A for ; Fri, 21 May 2004 20:50:50 -0300 (ADT) Received: from [192.168.0.13] (really [68.226.6.208]) by lakermmtao12.cox.net (InterMail vM.6.01.03.02 201-2131-111-104-20040324) with ESMTP id <20040521235052.OPZH7314.lakermmtao12.cox.net@[192.168.0.13]>; Fri, 21 May 2004 19:50:52 -0400 From: Robert Treat To: Subject: Re: pg_hba.conf Date: Fri, 21 May 2004 20:04:26 -0400 User-Agent: KMail/1.5 Cc: References: <2898C2526ECBEB448D434BA1F3027909034D975B@scsdcmail1.ameritrade.com> In-Reply-To: <2898C2526ECBEB448D434BA1F3027909034D975B@scsdcmail1.ameritrade.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200405212004.27064.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/237 X-Sequence-Number: 13553 can you ping the server that postgresql is living on? or maybe your misrepresenting the error message... what program are you using to try and connect? can you verify that tcpip_sockets is turned on the server? also, if it is a database problem there will be an exact error message being reported in the logs of type FATAL, can you send us that? Robert Treat On Friday 21 May 2004 17:01, LSanchez@ameritrade.com wrote: > Thanks Robert! > > I did that as well and still didn't work. Any other ideas? > > -----Original Message----- > From: Robert Treat [mailto:xzilla@users.sourceforge.net] > Sent: Friday, May 21, 2004 4:41 PM > To: LSanchez@ameritrade.com > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] pg_hba.conf > > On Thu, 2004-05-20 at 19:52, LSanchez@ameritrade.com wrote: > > I'm trying to access our test postgreSQL server via VPN and even > > though > > > I already setup the host for the vpn's ip address, I'm still getting > > an > > > error similar to "host for vpn address does not exist" > > > > What am I doing incorrectly? > > The error similar to that that I am thinking of would indicate that the > ip address of your client machine does not fall into the scheme laid out > in your pg_hba.conf. Most likely you need to add your home machines ip > into the pg_hba.conf (or open up one of the existing entries to include > the machine your connecting from) > > HTH > > Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL