Skip site navigation (1) Skip section navigation (2)

Re: pg_hba.conf

From: <LSanchez(at)ameritrade(dot)com>
To: <xzilla(at)users(dot)sourceforge(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_hba.conf
Date: 2004-05-24 17:02:12
Message-ID: 2898C2526ECBEB448D434BA1F302790902E93CFB@scsdcmail1.ameritrade.com (view raw or flat)
Thread:
Lists: pgsql-admin
Yes I can ping the server if not connected via VPN. 

I'm using EMS PostgreSQL Manager, which works if not via VPN. 

Yes, postgresql.conf's tcpip_socket = true.

The log says: FATAL: No pg_hba.conf entry for host 10.29.15.113, user
postgres, database TEST.

Thanks for your help!

Regards,
- Lily Anne


-----Original Message-----
From: Robert Treat [mailto:xzilla(at)users(dot)sourceforge(dot)net] 
Sent: Friday, May 21, 2004 8:04 PM
To: LSanchez(at)ameritrade(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] 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

Responses

pgsql-admin by date

Next:From: Ericson SmithDate: 2004-05-24 17:13:12
Subject: Re: Clustering Postgres
Previous:From: Greg SpiegelbergDate: 2004-05-24 16:28:32
Subject: Re: Clustering Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group