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