Re: pg_hba.conf is driving me nuts - Mailing list pgsql-admin

From olivier boissard
Subject Re: pg_hba.conf is driving me nuts
Date
Msg-id 47657E70.5030103@cerene.fr
Whole thread Raw
In response to Re: pg_hba.conf is driving me nuts  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Peter Eisentraut a écrit :
> Julio Leyva wrote:
>
>> also make sure you started postgesql with -i option, so you can connect
>> from the lan
>>
>
> He said he had set listen_addresses to '*', which is equivalent.
>
>
to allow every one :

host    all         all         0.0.0.0           0.0.0.0 trust


and set in postgresql.conf :
log_connections = on
to look if connections are opened

Are you running from a linux server ?
Sometimes we must look at /etc/hosts.deny and /etc/hosts.allow to make
sure remote hosts are not rejected.

maybe you can use nmap to see if port is open .


Olivier

pgsql-admin by date:

Previous
From: "Usama Dar"
Date:
Subject: Re: reading pg_stat_activity view
Next
From: "Usama Dar"
Date:
Subject: Re: Canceling process from pgAdmin III