Cannot connect from local network to my postgresql server

Hi,

I use ubuntu 14.01 and i install a postgresql 9.3 server. I want to connect
an other pc from local network to this server. But the server seems to only
listen on localhost.

There is the conf files :

pg_hba.conf :

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32
@authmethodhost@
# IPv6 local connections:
host    all             all             ::1/128
@authmethodhost@
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     @default_username@
@authmethodlocal@
#host    replication     @default_username@        127.0.0.1/32
@authmethodhost@
#host    replication     @default_username@        ::1/128
@authmethodhost@

host all all 192.168.1.127 255.255.255.0 md5

(192.168.1.127 is the ip of the pc i want to connect)

postgresql.conf (with the only lines i changed) :

# - Connection Settings -

tcpip_socket = true

listen_addresses = '*'            # what IP address(es) to listen on;
                    # comma-separated list of addresses;
                    # defaults to 'localhost'; use '*' for all
                    # (change requires restart)
port = 5432                # (change requires restart)

my iptables are setup :

:~$ sudo iptables -L
[sudo] password for dlefebvre:
Chain INPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     tcp  --  anywhere             anywhere             tcp
dpt:postgresql

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     tcp  --  anywhere             anywhere             tcp
dpt:postgresql
:~$

and so, using netstat it seems like the server only listen on localhost :

:~$ netstat -lt
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State
tcp        0      0 dlefebvre-ubuntu:domain *:*                     LISTEN
tcp        0      0 localhost:ipp           *:*                     LISTEN
tcp        0      0 localhost:postgresql    *:*                     LISTEN
tcp6       0      0 ip6-localhost:ipp       [::]:*                  LISTEN
:~$

Logs dosen't show any errors and of course the server is running, i can
access in localhost without any trouble.

I google all link i could found, every people who had the same issue made
mistake in configuration file. I think i am not, this is why i request your
help.

Thanks for your time, i stay avaible if you need any more information.

Cheers, Damien Lefebvre.




--
View this message in context:
http://postgresql.nabble.com/Cannot-connect-from-local-network-to-my-postgresql-server-tp5845229.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.