| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Usama Dar | 2007-12-16 19:41:09 | Re: Canceling process from pgAdmin III |
| Previous Message | Usama Dar | 2007-12-16 19:37:19 | Re: reading pg_stat_activity view |