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!
Best Answer
Use services (start -> run -> services.msc) and look for the postgresql-[version] service.
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.