Wednesday, August 13, 2014

Enabling connection to PostgreSql 9.3 from remote machines

To enable connections from a remote machine in PostgreSql 9.3 you only need to update the pg_hba.conf file.

Add a new line to the file as following:

host      all       all         XXX   255.255.255.255  trust

XXX = the ip address of the computer that your application is running on.  If your ip address is say 192.168.123.250 it is ok to enter it in pg_hba.conf as 192.168.123.0.  The .0 acts a wildcard in case your
computer is assigned a new ip address at a later time (hopefully it will be in the same range as the original...)

As a side note a message posted on postgres.org had mentioned about the need to update tcpip_socket = false to true in postgresql.conf.
http://www.postgresql.org/message-id/1087704118.23312.35.camel@localhost.localdomain

However I did not find such as entry in the postgresql.conf for PostgreSql 9.3; further more did not have the need for this to enable remote access in PostgreSql 9.3

No comments:

Post a Comment