postgresql / pgAdmin - server doesn't listen issue

Question

I am setting up postgresql / pgadmin on my new macbook pro. However, when I register a new server, I get the error:

Server doesn't listen
The server doesn't accept connections: the connection library reports 
could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

I browsed this issue and apparently the answer is to edit the pg_hba.conf file. However, i need help with:

1) How do I find & open that file?

2) Once I open it, what statements do I need to add to fix the issue?

Can someone help?

Thanks in advance!

The file and its location and syntax is documented in the manual: postgresql.org/docs/current/static/client-authentication.html See also here — user330315
– user330315, Commented May 29, 2016 at 22:06

Marlon Abeykoon · Accepted Answer · 2016-06-07 08:56:49Z

1

It is situated inside the data folder.

Eg: PostgreSQL\9.4\data\pg_hba.conf

There you will find the following place.

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5

If you want to access from different IP add a copy of the same line changing the IP. Its well explained here.

And also I suggest you to check the postgresql.conf placed in the same directory for the following line whether its commented on not.

#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '*'      # what IP address(es) to listen on;

answered Jun 7, 2016 at 8:56

Marlon Abeykoon

12.6k4 gold badges60 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql / pgAdmin - server doesn't listen issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related