help connecting to database using pgadmin

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: Raw Message | Whole Thread | 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.

Browse pgadmin-support by date

  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