Can someone have a look at my pg_hba.conf file ?
От | Steven De Vriendt |
---|---|
Тема | Can someone have a look at my pg_hba.conf file ? |
Дата | |
Msg-id | 8d2ea9d70706040805m5e919c26i8d5c62110879343@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Can someone have a look at my pg_hba.conf file ?
Re: Can someone have a look at my pg_hba.conf file ? |
Список | 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 по дате отправления: