From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'leo(at)junquera(dot)com'" <leo(at)junquera(dot)com>, "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: help connecting to database using pgadmin |
Date: | 2002-01-27 21:33:52 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB10B52AE@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Leonardo Junquera [mailto:leo(at)junquera(dot)com]
> Sent: 26 January 2002 03:50
> To: pgadmin-support(at)postgresql(dot)org
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - WCP | 2002-01-28 10:00:04 | Re: help connecting to database using pgadmin |
Previous Message | Leonardo Junquera | 2002-01-26 03:50:19 | help connecting to database using pgadmin |