Remote access to PostgreSQL server

Edit “postgresql.conf” file
change listen_addresses = ‘localhost’ to listen_addresses = '*'

Edit “pg_hba.conf” file
Assuming your ip address is W.X.Y.Z, add following line at the end of the file
host all all W.X.Y.Z/32 trust

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.