From: | "Leonardo Junquera" <leo(at)junquera(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | help connecting to database using pgadmin |
Date: | 2002-01-26 03:50:19 |
Message-ID: | 200201252250.AA1087242414@mail.junquera.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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]
Any suggestions would be appreciated.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-01-27 21:33:52 | Re: help connecting to database using pgadmin |
Previous Message | Dave Page | 2002-01-25 21:47:29 | Re: security wizard enhancements |