Re: help connecting to database using pgadmin

[Dave Page]

> -----Original Message-----
> From: Leonardo Junquera [mailto:[EMAIL PROTECTED]] 
> Sent: 26 January 2002 03:50
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] help connecting to database using pgadmin
> 
> 
> i've got pgadmin II v 1.2 and postgre 7.1.1 and I'm having 
> trouble connecting to my database.  Pgamin is running on xp 
> and postgre is running on a redhat linux box.
> 
> The error i'm getting happens when i'm trying to connect:
> Number: -214721843
> Description: No pg_hba.conf entry for host 192.168.0.2, user 
> leoj, database sbm
> 
> There is a line in my pg_hba.conf that reads:
> host         sbm         192.168.0.2   255.255.255.255    password 
> leoj
> 
> I've tried it with with a number of combination including:
> host   all   192.168.0.2   255.255.255.0    trust
> host   sbm   192.168.0.2   255.255.255.255  ident  leoj
> 
> I've started postmaster with -i and I have tcpip_socket = 
> true in postgresql.conf.
> 
> When i run "netstat -ta" i get:
> tcp        0      0 *:postgres              *:*                    
> LISTEN
> 
> When i run "ps -aux|grep postgre" i get:
> postgres 22482  0.0  0.0  5052    0 ?        SW   22:48   0:00
> [postmaster]
> 

Hmm, everything looks OK as you've described it. I assume 192.168.0.2 is the
correct address for your XP box? You are obviously connecting to the server
as you are getting that error message.

I know it sounds odd, but are you sure you're editting the correct
pg_hba.conf file? If you are running a hand compiled PostgreSQL on Redhat,
it is possible that there is more than one PGDATA directory - the default
from the Redhat RPM installation, and the one you're trying to use... Does
that make any sense? :-)

Regards, Dave.