pgadmin connecting to postgresql ;error: server not listening

Question

I am trying to make a new server registration in pgAdmin but I am getting this error:

"server is not listening"

The IP Address of the server is : X.Y.Z.W

And in pg_hba.conf I set accesses like:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
  # "local" is for Unix domain socket connections only
    local   all             all                                     peer
  # IPv4 local connections:
  host    all             all             0.0.0.0/0          md5
  host    all             all             127.0.0.1/32            md5

 # IPv6 local connections:
    host    all             all             ::1/128                 ident

when I run : su postgres and then: psql -h X.Y.Z.W -d test -U test There is no error.

how can I solve the error.

Thank you

Did you used the same machine for pgAdmin and psql ? Are you listening to every hosts in your postgresql.conf file ? — Arthur
– Arthur, Commented Aug 26, 2013 at 13:07
Then it becomes tricky... You could try to re-install pgAdmin, and make sure its version is compatible with your server version. Also, you should try to disable your firewall on client side if you have one. I don't see anything else yet. — Arthur
– Arthur, Commented Aug 26, 2013 at 13:31

John Macl · Accepted Answer · 2013-08-26 15:17:41Z

1

So I re-installed pgadmin3 and it worked fine.

answered Aug 26, 2013 at 15:17

John Macl

3312 gold badges5 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

pgadmin connecting to postgresql ;error: server not listening

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