Skip site navigation (1) Skip section navigation (2)

Re: pg_hba.conf is driving me nuts

From: olivier boissard <olivier(dot)boissard(at)cerene(dot)fr>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org, Julio Leyva <jcleyva(at)hotmail(dot)com>, Klay Martens <kmartens(at)wol(dot)co(dot)za>
Subject: Re: pg_hba.conf is driving me nuts
Date: 2007-12-16 19:37:20
Message-ID: 47657E70.5030103@cerene.fr (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-admin by date

Next:From: Usama DarDate: 2007-12-16 19:41:09
Subject: Re: Canceling process from pgAdmin III
Previous:From: Usama DarDate: 2007-12-16 19:37:19
Subject: Re: reading pg_stat_activity view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group