
Step 1
Edit file:
nano /etc/postgresql/9.3/main/pg_hba.conf
Add a line with your IP or mask, like for example:
host all all 10.100.20.200/32 trust
Step 2
Edit file:
nano /etc/postgresql/9.3/main/postgresql.conf
Uncomment line:
listen_addresses = 'localhost'
And replace localhost with * to listen on all interfaces. If you know the IP, just write it here.
Step 3
Restart Postgres:
/etc/init.d/postgresql restart
Now you should be able to connect from a remote host, for example with pgAdmin III:
If you think my content is worth it you can
Buy me a Ko-fi
