postgresql login from remote

Posted by Hellnar on Server Fault See other posts from Server Fault or by Hellnar
Published on 2009-11-18T11:17:27Z Indexed on 2010/05/09 10:08 UTC
Read the original article Hit count: 316

Filed under:
|
|

Hello, I want to give remote access to my postresql db (8.2) to computers that are at the same lan, at the default config I have added this line to pg_hba.conf where xxx.xx.xx.xx is the ip of the machine that hosts postgresql. This machine is a windows 2k server.

# IPv4 local connections:
host    all         all         0.0.0.0/0         password
host    all         all         xxx.xx.xx.xx/24         password

There no firewall or such blocking the connection between and `listen_addresses = '*' for postgresql.conf .

© Server Fault or respective owner

Related posts about postgresql

Related posts about port