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

From: "Steven De Vriendt" <gisaalter(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can someone have a look at my pg_hba.conf file ?
Date: 2007-06-04 15:05:14
Message-ID: 8d2ea9d70706040805m5e919c26i8d5c62110879343@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2007-06-04 15:07:12 Re: NULLS and User Input WAS Re: multimaster
Previous Message Joshua 2007-06-04 15:04:59 current_date / datetime stuff