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
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 |