arundhaj

regression towards the datascience

Connect remote postgresql server with pgAdmin

 

When trying to connect remote postgresql server with pgAdmin, leads to "Unable to connect" error.

To enable pgAdmin to connect, edit the following configuration in the server:

$ sudo vim /etc/postgresql/9.3/main/postgresql.conf
   listen_address = '*'

$ sudo vim /etc/postgresql/9.3/main/pg_hba.conf
   local    all     postgresql          trust
   host     all     all     0.0.0.0/0   md5

$ sudo service postgresql restart

Hope this helps.

Comments