Allow remote connections for PostgreSQL 9.3

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