Often it's good to access databases directly from desktop. Or maybe you want your database server to be different from your application server. Whatever your reason is, the requirement is enabling remote access to your PostgreSQL database server.

It's very simple procedure. First locate your DB configuration files. Commonly they lives under [inline-code]/etc/postgresql/9.3/main/[/inline-code] directory. Be sure to replace '9.3' with your own database version.

Now open up the file [inline-code]pg_hba.conf[/inline-code] with your favorite text editor and paste the bellow code at the end of the file:

host all all  0.0.0.0/0 md5

Next open up [inline-code]postgresql.conf[/inline-code] and change the value of [inline-code]listen_addresses = 'localhost'[/inline-code] to something like this:

listen_addresses = '*'

Simply restart your server:

sudo service postgresql restart

You should be good to go by now!

Test your setup:

psql -h server.ip -U postgres