Re: pg_hba.conf

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(at)ameritrade(dot)com wrote:
> Thanks Robert!
>
> I did that as well and still didn't work. Any other ideas?
>
> -----Original Message-----
> From: Robert Treat [mailto:xzilla(at)users(dot)sourceforge(dot)net]
> Sent: Friday, May 21, 2004 4:41 PM
> To: LSanchez(at)ameritrade(dot)com
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] pg_hba.conf
>
> On Thu, 2004-05-20 at 19:52, LSanchez(at)ameritrade(dot)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