Pgadmin PostgreSQL could not connect to server


1). $sudo vim /etc/postgresql/9.3/main/pg_hba.conf

Edit the below line in pg_hba.conf
# IPv4 local connections:

host  all all 127.0.0.1/32 md5
to
host  all all all  md5

2). sudo vim/etc/postgresql/9.3/main/postgresql.conf

# - Connection Settings -

listen_addresses = '*'

# /etc/init.d/postgresql restart

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s