PostgreSQL database service

Question

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!

Answer 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.

Answer 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

Answer 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.

Answer 4

You only need to do

pg_ctl register

then execute servcies.msc

enable the "PostgresSQL" and set to auto

then, your postgresql will run like the "server".

Answer 5

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

Answer 6

The solution was simply to comment the lines "work_mem=256MB" and "maintenance_work_mem=$3GB" in the file postgresql.conf and try to start the postgresql service. (start -> run -> services.msc) and look for the postgresql-[version] service then right click and start.

Answer 7

Checking the port may work.

On pgAdmin page at the top, go to Properties and check the port if it is same with the one provided during the setup. If not click the edit button on the top right and change the port.

Answer 8

Your server running on port 5432 but in the properties, the port is set to 5433.

You must go to pgAdmin, click on database version, ex: PostgresSQL 10 and edit properties.

A new window appears and you need to change the port to 5432 [this is default port].

Answer 9

1. check conenctionstring
2. check SSL
3. check firewall
4. if u use VS studio, check for db driver

Answer 10

I'm not on windows, but I think you can use the pgAdmin you just installed to configure a server connection and start the server.

Answer 11

Your server might not be running. This can have 2 issus IMO:

1. I had the problem that the permissions were not set on the postgres folders and so the service was not able to start. I have no idea why that happend but giving proper permissions on the root postges folder and subfolders did the trick. If I recall it correctly, postgres is also installed as a service so you should find it in the Service List

2. To start the server, you have a startcommand in your Startmenu. Somewhere at Start -> PostgreSQL -> Start Service/Server/... (haven't used it on Windows for a long time but it should be there).

Answer 12

Please Download from this

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

install above downloaded file

then

The solution was simply to delete %appdata%\pgAdmin (win key + r then type %appdata% got folder pgAdmin) which was created by an earlier version. On systems other than Windows, there probably is a pgAdmin directory in your user directory. Of course, all session settings etc. are gone after deleting this.

Answer 13

you to restart services PostgreSQL from task manager click ctrl+alt+delete then chose services the postgresql-[version] chose the option to run automatically then start and apply ->ok

Answer 14

Use Services

1. Windows -> Services
2. check your PostgresSQL is started or in running state. ( If it's not then start your services for PostgresSQL).
3. Close services and check again with your PostgresSQL.

This will start PostgresSQL servers as normal.

Answer 15

On windows, Just go to the 'Services'. Start/Restart the postgresql-X64 service (click on this service, a dialog box will appear, click Start then OK).Refresh the browser window where postgre db is appearing. It worked for me as my service was in stopped state somehow.