PostgreSQL database service

I downloaded PostgreSQL from their site - http://www.postgresql.org/download/windows

However, I can't create a database from pgAdmin and get a message:

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?

EDITED

Let me explain myself. I am trying to run the service. I tried running postgres.exe from the command line but still it does not run.

What could run the database?

EDITED

The problem was with my installation file. I downloaded it again - and it worked well!

Solution 1:

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 the One Click Installer, which still allows proper configuration of installation directory despite its name.

Solution 2:

I have the solution to this problem enters (Start -> Run -> services.msc) are looking for the postgresql service once you localizas le das Properties---> login and you disable the account you have and what you leave as the local system account , save and restart the programs pgadmin3 and ready should operate.

Greeting from Colombia

Solution 3:

You might get a more descriptive error message if you tried to start the service from command line using this command:

"C:\Program Files\PostgreSQL\9.5\bin\pg_ctl.exe" start -N "postgresql-x64-9.5" 
  -D "C:\Program Files\PostgreSQL\9.5\data" -w

The log file would be at C:\Program Files\PostgreSQL\9.5\data\pg_log. Note that paths and service name might be different depending on your installation.

Solution 4:

(start -> run -> services.msc) and look for the postgresql-[version] service then right click and enable it