CODEWITHSUNDEEP
databasepostgresqlconnectionpgadmin
John Macl
John Macl

Reputation: 331

pgadmin connecting to postgresql ;error: server not listening

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

Upvotes: 1

Views: 2341

Answers (1)

John Macl
John Macl

Reputation: 331

So I re-installed pgadmin3 and it worked fine.

Upvotes: 1

Related Questions