help connecting to database using pgadmin - Mailing list pgadmin-support

From Leonardo Junquera
Subject help connecting to database using pgadmin
Date
Msg-id 200201252250.AA1087242414@mail.junquera.com
Whole thread Raw
List 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.


pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: [Refresh] button on SQL Output window
Next
From: Dave Page
Date:
Subject: Re: help connecting to database using pgadmin