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