unable to connect to server for Postgres

Question

I have a problem to connect server for Postgres after I updated my windows.Before I update there is no problem to open the database. My database in Postgres also gone. When I want to create my new database it show this error:

Unable to connect to server: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

Is Postgres starting on your PC (which O.S and Postgres version are you using?)? Check that windows firewall isn't blocking the ports. — n34_panda
– n34_panda, Commented Nov 10, 2016 at 16:25
i am using windows 10 and my postgres is 9.6.How to check windows firewall blocking the port?@n34_panda — SySyBy
– SySyBy, Commented Nov 10, 2016 at 16:34
Open Up "Control Panel", select "System and Security" and choose "Windows Firewall" or simply search for "Windows Firewall" then you'll see some radio buttons. Easiest quick test is to switch them all off and see if the service works and you can connect. — n34_panda
– n34_panda, Commented Nov 10, 2016 at 16:36

gagan chhabra · Accepted Answer · 2020-02-23 07:06:16Z

147

On windows, Just go to the 'Services'. Start/Restart the postgresql-X64 service. It worked for me as my service was in stopped state somehow.

answered Feb 23, 2020 at 7:06

gagan chhabra

1,5711 gold badge9 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Matthew Wolman Over a year ago

What if I can't find the postgresql-X64 service anywhere in my services? Why is it not there?

sophievda Over a year ago

@MatthewWolman in this post: 'How to run PostgreSQL as a service in Windows' is elaborated how you can start the service. Another solution is to reinstall postgresql as explained in 'Connection refused in local postgresql' . Hope this will help.

Helene Over a year ago

This was exactly what happened to me. Thanks so much.

Bilal Over a year ago

if the start button is disabled. then goto properties and select manual and then click on start

Franc Drobnič · Accepted Answer · 2017-03-14 01:12:07Z

26

There are two items to configure if your server isn't on localhost:

find your postgresql.conf and add your server's public IP address to the end of the setting listen_addresses (separate multiple entries by commas); uncomment the line if it is commented out (e.g. with '#')
add a line to pg_hba.conf containing your client's IP address - you may copy the line containing 127.0.0.1 and change only the IP address

On Ubuntu, these files are in /etc/postgresql/<version>/main/.

answered Mar 14, 2017 at 1:12

Franc Drobnič

1,10512 silver badges15 bronze badges

3 Comments

nbs Over a year ago

On CentOS Linux (7), these files are in /var/lib/pgsql/<version>/data/; update the entries as above, and restart pgsql server sudo systemctl restart postgresql-14

NOCARRIER Over a year ago

I had to repeat this process on Windows after upgrading my Postgres software version and being unable to reconnect to my local db.

Albert Over a year ago

It can't be overstated how many different ways there are to block traffic to your postgres instance. But yes, postgresql.conf and pg_hba.conf are the main ones. Always good to lint/scan them. Example one that can analyze Postgres confs e.g. is github.com/coguardio/coguard-cli

Andreas Alamanos · Accepted Answer · 2020-09-12 13:55:33Z

19

In my case I couldnt' open the pgAdmin4, for some reason. I use Postgresql 10 and pgAdmin4

The port in the postgresql.conf was not the same as in the pgAdmin4 --> postgreSQL 10 --> properties --> Connection --> port.

I fixed it and it worked. Check if those 2 are in line.

answered Sep 12, 2020 at 13:55

Andreas Alamanos

3484 silver badges11 bronze badges

2 Comments

John S John Over a year ago

This worked for me. My Postgres port was 5432 but pgAdmin was connecting to 5433.

Aymen Bou Over a year ago

This worked for me on Windows 10, simply just changing the port in the Properties of the server to what was in postgresql.conf solved this issue.

VADHAN · Accepted Answer · 2021-05-31 05:03:53Z

17

First press win key+R Search for services.msc A window will open in that find postgresql-x64-13 and open that, in that tab click start option For me its works perfectly.

answered May 31, 2021 at 5:03

VADHAN

2413 silver badges2 bronze badges

Comments

Никита Мельников · Accepted Answer · 2021-05-15 17:27:46Z

12

Go to PgAdmin
Right click on PostgreSQL 3.Choose properties
At the top, select connection
Try changing the port from 5433 to 5432 or vice versa.

And re-enter.

answered May 15, 2021 at 17:27

Никита Мельников

1111 silver badge2 bronze badges

1 Comment

rickster Over a year ago

currently my postgres v14 is running on port 5433, and I deleted v13 completely which was running on port 5432... and I am not able to use psql command... don't know why :(.. what should I do any idea ? And on changing port from pgAdmin I am not able to connect.. giving that same error..

devyan91 · Accepted Answer · 2020-09-10 18:00:54Z

9

On windows, Just go to the 'Services'. Start/Restart the postgresql-X64 service. It worked for me as my service was in stopped state somehow.

worked for me

answered Sep 10, 2020 at 18:00

devyan91

991 silver badge6 bronze badges

Comments

Tim Uzlov · Accepted Answer · 2020-08-07 21:49:35Z

7

Faced this problem immediately after installing on Windows. At startup the pgAdmin gave this error which means that the server is not running. For me the solution was: Start -> Control panel -> Administration -> Services -> postgresql-x64-12 - start or restart

answered Aug 7, 2020 at 21:49

Tim Uzlov

3013 silver badges6 bronze badges

Comments

Nitin Nain · Accepted Answer · 2021-08-07 14:30:05Z

7

This happened because I installed two versions of Postgres (v12 and v13). Psql 12 was installed later so got the port 5433. I needed to use Postgres 12. To fix this particular case:

Go to Program Files/Postgres/<required_version>/data

Open the postgresql.conf file

Search for Port and change the port number to 5432.
Open Windows Services (Press Cmd + R then type services.msc)
Stop the service for the version you don't want (You can stop it permanentally from the Right Click > Properties menu.)
Start the service for the version you want.

answered Aug 7, 2021 at 14:30

Nitin Nain

5,5231 gold badge40 silver badges51 bronze badges

1 Comment

Nguyen Nhut Tien Over a year ago

same to me. I installed two Postgres and need to change port.

Mace · Accepted Answer · 2023-05-03 12:37:20Z

5

Summary: There are 2 Solutions:

Open Services and make sure that postgresql-x64-14 is running.
Go to C:\Program Files\PostgreSQL\14\data and open postgresql.conf with notepad, find and change port to e.g 5432 and after that open Services and restart postgresql-x64-14.

edited May 3, 2023 at 12:37

answered Apr 11, 2022 at 16:06

Mace

1442 silver badges8 bronze badges

1 Comment

Jeremy Caney Over a year ago

There are twenty existing answers to this question, including a top-voted answer with nearly one hundred votes. Are you certain your solution hasn't already been given? If not, why do you believe your approach improves upon the existing proposals, which have been validated by the community? Offering an explanation is always useful on Stack Overflow, but it's especially important where the question has been resolved to the satisfaction of both the OP and the community. Help readers out by explaining what your answer does different and when it might be preferred.

B G · Accepted Answer · 2021-03-12 14:33:39Z

4

goto service and start postgresql-x64-10 service

steps

run -> services.msc -> find postgresql-x64-10 -> start the service
services image

answered Mar 12, 2021 at 14:33

B G

396 bronze badges

Comments

James Karino Simel · Accepted Answer · 2022-07-19 15:19:10Z

4

When I run psql, it gave me the same error, and it was because I changed the port while setting Postgres in the installation process.

I had to change back to the default port 5432 in PostgreSQL.conf (which can be found in the data directory) i.e

C:\Program Files\PostgreSQL\14\data>

The problem is no more!

answered Jul 19, 2022 at 15:19

James Karino Simel

515 bronze badges

Comments

Harsha Biyani · Accepted Answer · 2021-11-23 06:24:41Z

I think the problem is with your server listening to default public IP address. For example in the PostgreSQL package, your sever is set to listen to localhost as default public address which when you launch/ run database, the address might be something like '127.0.0.1'

To fix you can try change localhost to '' as in "listen_addresses = ''".

As seen as "listen_addresses = 'localhost'" under "Connection Settings" in the postgresql.conf file.

Also to access your postgresql.conf file, go to:

On Windows, the file is in /Program Files/PostgreSQL/<version>/share/. On Ubuntu, these files are in /etc/postgresql/<version>/main/.

P.S: Changing the defaults 'localhost'; to '*' will let your server listen to any public database address either "localhost, 127.0.0.1 etc.

I know you might have fix this, just for others that might run into the same issue in the future. Hope it was helpful

Manoj Swami · Accepted Answer · 2021-07-06 02:54:58Z

2

This is a note for a normal user. If using an official installer, it should have a built-in service,

Win+R and type services.msc
Search Postgres service based on the version installed, e.g., "postgresql-x64-13 - PostgreSQL Server 13"
Click stop, start, or restart the service option
If you don't see start/stop or if these buttons are disabled, then double-click on the PostgreSQL and change startup type to automatic and click on start. This will start the PostgreSQL every time automatically whenever you start your system.

answered Jul 6, 2021 at 2:54

Manoj Swami

1413 silver badges12 bronze badges

1 Comment

Ali.M.Kamel Over a year ago

works for anyone who killed the process of postgresql service from the Task-manager for whatever reason

ouflak · Accepted Answer · 2021-10-01 17:28:45Z

2

I had the same issue, so, I uninstalled postgres. And during reinstallation I noticed the error:
"Failed to load SQL modules into the database cluster"
And:
"Problem running post installation step.Installition may not complete correctly. Error reading file C:/Program Files/PostgreSQL/14/data/postgresql.conf".

I cancelled the installation and then tried again, but with a plain-text password this time, and it worked. It turned out that the special characters in my password were the problem.

edited Oct 1, 2021 at 17:28

ouflak

2,56310 gold badges46 silver badges53 bronze badges

answered Oct 1, 2021 at 14:48

KanjooM

212 bronze badges

Comments

uosjead · Accepted Answer · 2018-05-10 13:42:38Z

1

I got this error message when I moved my database to another computer.

I also got some error messages when starting the server first with

pg_ctl -D /wherever/your/database/is start

which were

pg_ctl: another server might be running; trying to start server anyway server starting

DETAIL: File "/wherever/your/database/is/PG_VERSION" does not contain valid data.

HINT: You might need to initdb.

In my case rather than running initdb this command actually fixed the issue

pg_ctl -D /wherever/your/database/is restart

answered May 10, 2018 at 13:42

uosjead

4366 silver badges5 bronze badges

Comments

Nirmal · Accepted Answer · 2021-03-30 12:18:59Z

1

You might have changed the permissions of the 'PostgreSQL 12' in 'services.msc'. Or maybe it is not started and you are trying to start the server when Postgre 12 is not running.

Try these:

Try to start the 'PostgreSQL 12' in 'services.msc' manually.
Try restarting your PC
If nothing helps, try reinstalling PostgreSQL (pgAdmin 4) from the scratch.

answered Mar 30, 2021 at 12:18

Nirmal

771 silver badge8 bronze badges

Comments

Tony Joseph · Accepted Answer · 2021-04-22 14:42:48Z

1

Go to C:\Program Files\PostgreSQL\13\data, edit postgresql.conf with notepad.

Change:

#port = 54XX

To:

port = 54XX

(change requires restart)

restart service at "service system" on window.

edited Apr 22, 2021 at 14:42

Tony Joseph

1,9322 gold badges16 silver badges17 bronze badges

answered Apr 20, 2021 at 17:54

Charlycris

112 bronze badges

Comments

DINA TAKLIT · Accepted Answer · 2022-04-13 06:42:42Z

1

For me I was getting this error and unable to open the server in PgAdmin is because I very often forgot to start the server, one for the way you can start the server with is by running this commands on cmd, make sure you provide the right path

cd "C:\Program Files\PostgreSQL\14\bin"
pg_ctl -D "C:\Program Files\PostgreSQL\14\data" start

answered Apr 13, 2022 at 6:42

DINA TAKLIT

8,50410 gold badges84 silver badges92 bronze badges

Comments

Ndaruga · Accepted Answer · 2024-03-15 10:59:45Z

1

For me on windows this worked by changing the configuration file default settings as follows.

In the postgresql.conf file in the C://ProgramFiles/PostgrSQL/<version>/data directory, Under CONNECTION AND AUTHENTICATION, ensure

listening_addresses = '127.0.0.1'

and

port = 5432

then press Win+R and type services.msc, look for PostgreSQL then restart the service.

That should work.

answered Mar 15, 2024 at 10:59

Ndaruga

313 bronze badges

Comments

khush · Accepted Answer · 2024-04-12 06:08:13Z

1

I had installed postgresql@12 using homebrew. These steps worked for me.

rm -rf /opt/homebrew/var/postgresql@12/postmaster.pid                        

brew services restart postgresql@12

answered Apr 12, 2024 at 6:08

khush

2,8072 gold badges18 silver badges36 bronze badges

Comments

Jeremy Thompson · Accepted Answer · 2021-07-14 01:40:56Z

0

Using psql with single quotes fails:

psql -c 'Select version();' 'postgresql://username:[email protected]:8080/the_db'

psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

Using double quotes works:

psql -c "Select version();" "postgresql://username:[email protected]:8080/the_db"

PostgreSQL 10.14 on x86_64-pc-linux-gnu, compiled by x86_64-unknown-linux-gnu-gcc (GCC) 4.9.4, 64-bit (1 row)

answered Jul 14, 2021 at 1:40

Jeremy Thompson

66.3k38 gold badges225 silver badges344 bronze badges

Comments

Ashok Mehta · Accepted Answer · 2021-09-18 03:21:18Z

0

After a wasting 3-4 hrs i find the solution something like this

First set path in enviroment variable.And then make port and psql connecting same i.e 5432 or 5433

answered Sep 18, 2021 at 3:21

Ashok Mehta

11 bronze badge

Comments

Anurag A S · Accepted Answer · 2022-01-10 16:48:29Z

0

If you newly installed the pgAdmin, and you did not remember to install PostgreSQL at that time, you get that error. Make sure you install both pgAdmin And PostgreSQL.

edited Jan 10, 2022 at 16:48

Anurag A S

75112 silver badges26 bronze badges

answered Jan 6, 2022 at 11:14

sanket Walunj

1

Comments

emomaliev · Accepted Answer · 2022-03-24 04:41:46Z

0

And so for the new arrivals. If you are using pgAdmin and a Windows operating system, do some research to resolve the issue.

Make sure you have Postgresql installed or active

To do this, go to windows services (press Cmd + R and run the services.msc command)
Look in the list for a service called postgresql-x{BIT}-{Version}-PostgreSQL Server {Version}

Solution 1: If you don't find the service, then PostgreSQL is not installed or has been uninstalled, install it again.

Solution 2: If you find the service, but you still can't log in, then most likely the service is not active for some reason, select the service and click the Start or Restart button

answered Mar 24, 2022 at 4:41

emomaliev

2,4233 gold badges12 silver badges17 bronze badges

Comments

Muhammad Usama Rabani · Accepted Answer · 2023-03-16 10:30:08Z

0

If you are a Mac OS user, run these below two commands on termial,

rm /usr/local/var/postgres/postmaster.pid
brew services restart postgresql

answered Mar 16, 2023 at 10:30

Muhammad Usama Rabani

77611 silver badges18 bronze badges

Comments

Ahmer Shahid · Accepted Answer · 2024-01-11 19:27:48Z

0

The solution that worked for me:

Open the Services configuration window (you can access it from Windows Control Panel > Administrative Tools or from the Start menu when you type services or simply hold the Windows key + x and select services).
Find your service (in this example: PostgreSQL_For_Odoo) and double-click it to open its properties (or right click it and select Properties).
Go to the Log On tab and then check the Local System account radio button and apply.

I hope it will work for you as well :-)

answered Jan 11, 2024 at 19:27

Ahmer Shahid

1271 silver badge4 bronze badges

Collectives™ on Stack Overflow

unable to connect to server for Postgres

26 Answers 26

4 Comments

3 Comments

2 Comments

Comments

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

26 Answers 26

4 Comments

3 Comments

2 Comments

Comments

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related