PostgreSQL database service

WindowsDatabasePostgresql

Windows Problem Overview

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!

Windows Solutions

Solution 1 - Windows

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 - Windows

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 - Windows

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 - Windows

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

Solution 5 - Windows

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

Solution 6 - Windows

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.

Solution 7 - Windows

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.

Solution 8 - Windows

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

Solution 9 - Windows

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

Solution 10 - Windows

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.

Solution 11 - Windows

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

Solution 12 - Windows

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.

Solution 13 - Windows

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

Solution 14 - Windows

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.

Solution 15 - Windows

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.

Categories
Recommended Windows Solutions
Recommended Database Solutions
Recommended Postgresql Solutions

Previous Solution:

How to retrieve records for last 30 minutes in MS SQL?

SqlSql ServerTsql

Next Solution:

Why doesn't exec work in a function with a subfunction?

PythonExec

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionDejellView Question on Stackoverflow
Solution 1 - WindowsontrackView Answer on Stackoverflow
Solution 2 - WindowsJhonView Answer on Stackoverflow
Solution 3 - WindowsAhmad AbdelghanyView Answer on Stackoverflow
Solution 4 - WindowsAnaurgView Answer on Stackoverflow
Solution 5 - WindowsFrank LiaoView Answer on Stackoverflow
Solution 6 - WindowsRuslanView Answer on Stackoverflow
Solution 7 - WindowsMesut ASARKAYAView Answer on Stackoverflow
Solution 8 - Windowsuser14298639View Answer on Stackoverflow
Solution 9 - WindowsBonshingtonView Answer on Stackoverflow
Solution 10 - WindowsTobuView Answer on Stackoverflow
Solution 11 - WindowsDrColossosView Answer on Stackoverflow
Solution 12 - WindowsYasirPoongadanView Answer on Stackoverflow
Solution 13 - WindowsMohammed Al-ReaiView Answer on Stackoverflow
Solution 14 - WindowsAnkit GargView Answer on Stackoverflow
Solution 15 - WindowsSidrah Madiha SiddiquiView Answer on Stackoverflow