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.
