60

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!

Improve this question

17 Answers 17

Reset to default
145

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.

Improve this answer
8
  • 3
    I actually downloaded the OneClickInstaller. I don't know why I don't have the service in the list!
    – Dejell
    Commented Dec 19, 2010 at 11:58
  • 3
    When I start my postgresql9.1, it automaticall stoped by giving message some service stopautomatically.
    – ANIL
    Commented Jun 14, 2013 at 9:00
  • even when the service says it's stopped, the problem with refused connection is resolved (for me). trying to start the service again shows: postmaster.pid already exists. implying that postgres is now running
    – bibangamba
    Commented Oct 11, 2016 at 8:27
  • nice answer! for some reason this service has a tendency to crash and fail to start. if and when it does it isn't configured by default (although default is automatic start) to restart itself. I think Postgres really shit the bed on this one. I dunno why their DB is so unstable.
    – tatsu
    Commented Jan 17, 2018 at 8:42
  • @ANIL right click on the Postgresql sevice and select properties > go to log on tab > select first option and tick the check box> then start the service .
    – bit-shashank
    Commented Apr 20, 2018 at 8:06
3

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

Improve this answer
2

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.

Improve this answer
2

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

Improve this answer
2

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

Improve this answer
2

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

Improve this answer
1

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.

Improve this answer
1

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.

Improve this answer
1
  • This work for me. My server default port is 5433 when open PgAdmin it runs on 5432.
    – akshay_sushir
    Commented Nov 3, 2020 at 15:06
1

check if you really installed postgresSql from here not only the pgAdmin4

Improve this answer
0
  1. check conenctionstring
  2. check SSL
  3. check firewall
  4. if u use VS studio, check for db driver
Improve this answer
1
  • The connection string is fine. I am afraid that the server is not on. How do I turn it on?
    – Dejell
    Commented Dec 19, 2010 at 10:05
0

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.

Improve this answer
1
0

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

Improve this answer
1
  • 1
    I tried Start -> PostgreSQL -> Start Service/Server/ but there is not start service/server there
    – Dejell
    Commented Dec 19, 2010 at 11:21
0

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.

Improve this answer
0

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

Improve this answer
0

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.

Improve this answer
0

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.

Improve this answer
0

In my case, it was the Log On issue. This is how I solve the issue:

  1. Click the Windows button then search Services, open Services
  2. Search postgre-xxx service like this enter image description here
  3. If the status is empty, try right click then choose start
  4. If you get an error like 'could not start postgre...', try right click and choose properties
  5. choose Log On tab
  6. choose Local System Account

enter image description here

  1. click OK, then right-click the service and try to start the service
Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.