Tuesday, August 16, 2016

Postgresql: could not connect to server: Connection refused (0x0000274D/10061)

Question:

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?
Do I have to create a windows service? How is it called? Do I have to install it separately?

Answer:

Use services (start -> run -> services.msc) and look for the postgresql-[version] service.
  • If it is not there you might have just installed pgAdmin and not installed PostgreSQL itself.
  • If it is not running try to start it, if it won't start open the event-viewer (start -> run -> eventvwr) and look for error messages relating to the PostgreSQL service.
  • If it does start check the startup type, if you want it to start with windows it should be "Automatic"; or perhaps "Automatic, delayed start" if you don't want it to slow down startup too much.

Adding to the first, because in a different comment you've said the service isn't there. It is possible to download a standalone pgAdmin so you can connect to an external PostgreSQL database. It would seem you have done such a thing, or explicitly chosen to not add the service. Just try theOne Click Installer, which still allows proper configuration of installation directory despite its name.

Resource Link:


No comments:

Post a Comment