CODEWITHSUNDEEP
windows-7-x64postgresql-8.4
apaleja
apaleja

Reputation: 405

Not able to access Postgresql from CMD in Windows

I installed OpenGeo Suite 2.4.5 in windows 7. I want to access postgresql from cmd but when I trying to access it, I am getting this error: 

    psql: could not connect to server: Connection refused (0x0000274D/10061)
         Is the server running on host "???" and accepting
         TCP/IP connections on port 5432?
    could not connect to server: Connection refused (0x0000274D/10061)
        Is the server running on host "???" and accepting
        TCP/IP connections on port 5432?

Even I am getting same error when I tried to connect through QGIS. I think postgresql service is not listed thats why I am not able to access or connect it. Can some one please guide me.

Thank you

Upvotes: 0

Views: 575

Answers (1)

apaleja
apaleja

Reputation: 405

finally .. found the answer. .. on CMD run: c:\ psql -p 54321 -U postgres and similarly .. change port number to 54321 in QGIS to access it.

Upvotes: 1

Related Questions