pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: olivier boissard <olivier.boissard@cerene.fr>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-admin@postgresql.org, Julio Leyva <jcleyva@hotmail.com>
Cc: Klay Martens <kmartens@wol.co.za>
Subject: Re: pg_hba.conf is driving me nuts
Date: Sun, 16 Dec 2007 20:37:20 +0100
Message-ID: <47657E70.5030103@cerene.fr> (raw)
In-Reply-To: <200712161457.40344.peter_e@gmx.net>
References: <000001c83f0f$37df75b0$0100000a@klaydual>
	<BLU102-W6DCA4CC02447F22280C75A1600@phx.gbl>
	<200712161457.40344.peter_e@gmx.net>

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



view thread (9+ messages)

Message-ID: <47657E70.5030103@cerene.fr>
Permalink:  ../47657E70.5030103@cerene.fr/
Also on:    postgresql.org/message-id/47657E70.5030103@cerene.fr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: olivier.boissard@cerene.fr, peter_e@gmx.net, jcleyva@hotmail.com, kmartens@wol.co.za
  Subject: Re: pg_hba.conf is driving me nuts
  In-Reply-To: <47657E70.5030103@cerene.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox