Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux