Can someone have a look at my pg_hba.conf file ? - Mailing list pgsql-general

From Steven De Vriendt
Subject Can someone have a look at my pg_hba.conf file ?
Date
Msg-id 8d2ea9d70706040805m5e919c26i8d5c62110879343@mail.gmail.com
Whole thread Raw
Responses Re: Can someone have a look at my pg_hba.conf file ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Can someone have a look at my pg_hba.conf file ?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
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:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host     all     all     127.0.0.1/32               md5
# IPv6 local connections:
host    all         all         ::1/128               md5

# 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

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


Can someone help me out ?

Thanks !

Steven

pgsql-general by date:

Previous
From: Joshua
Date:
Subject: current_date / datetime stuff
Next
From: Andrew Sullivan
Date:
Subject: Re: NULLS and User Input WAS Re: multimaster