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.