Can someone have a look at my pg_hba.conf file ?

"Steven De Vriendt" <gisaalter@gmail.com> writes:

I'm trying to reach my postgres database via a remote connection. Yet
my connection is refused when I try to do that.

I think you need to fix listen_addresses, not pg_hba.conf.

regards, tom lane

On Mon, 2007-06-04 at 17:05 +0200, Steven De Vriendt wrote:

Hi,

I'm trying to reach my postgres database via a remote connection. Yet
my connection is refused when I try to do that.
I'm using Ubuntu Feisty
Following lines are now in my pg_hba.conf-file:

...

# Connections for all PCs on the subnet
#
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all 127.0.0.1/32 255.255.255.0 trust

That should be "host", not "local". Local means unix sockets on the
same machine. Secondly, 127.0.0.1 is itself only the local machine.
Third, if you specify a CIDR address (with /nn) you don't specify a mask
as well. You want something like "192.168.1.0/24" rather than
"127.0.0.1/32 255.255.255.0".

When I try the following command:

netstat -nlp | grep 5432

I see my subnet mask isn't included:

root@gis-webserver:~# netstat -nlp | grep 5432
tcp 0 0 127.0.0.1:5432 0.0.0.0:*
LISTEN 8292/postmaster
unix 2 [ ACC ] STREAM LISTENING 27162
8292/postmaster /var/run/postgresql/.s.PGSQL.5432

As Tom has already said, change listen_addresses in postgresql.conf and
restart the postmaster. If you were connecting with the pg_hba.conf you
have listed, you should be seeing:

psql: FATAL: missing or erroneous pg_hba.conf file
HINT: See server log for details.

Can someone help me out ?

Thanks !

Steven

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html