PostgreSQL Connection Refused

Question

I have installed PostgreSQL. However everytime I try to connect through PGAdmin or through psql it gives me the below error.

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?

I checked the postgresql.conf file and the line: listen_addresses = '*' isn't commented out.

Also this is how my pg_hba.conf file is set:

# IPv4 local connections:
  host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
  host    all             all             ::1/128                 trust

Can anyone please advise on how I can resolve this issue?

Thanks!

pg_hba.conf, not pg_hba.conf.txt

Roman Tkachuk
– Roman Tkachuk

2017-03-14 21:42:45 +00:00
Commented Mar 14, 2017 at 21:42 — Roman Tkachuk
– Roman Tkachuk, Commented Mar 14, 2017 at 21:42

tayfun Kılıç · Accepted Answer · 2018-10-31 19:32:31Z

9

Use services "start -> run -> services.msc" and look for the postgresql-[vers] service.

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.

answered Oct 31, 2018 at 19:32

tayfun Kılıç

2,9531 gold badge16 silver badges14 bronze badges

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

1 Comment

Albert Israel Over a year ago

After searching for several answers, this one worked for me! It simply needed to start the application (right click -> start). Then the error is gone!

Chris R · Accepted Answer · 2022-09-03 20:48:03Z

1

In my case it was postgres.config. The port was somehow changed to 5433 in there and I do not remember doing it myself lol. So make sure your ports are matching up in your project vs postgres.config

answered Sep 3, 2022 at 20:48

Chris R

292 bronze badges

1 Comment

Nick Muise Over a year ago

This may have happened if you installed a second version of PostgreSQL while another was already installed (maybe while trying to migrate from version X to version Y), as the second version will see that there is already another PostgreSQL installed and using port 5432, so will automatically set its port to 5433 in postgres.conf so that it doesn't conflict with the other PostgreSQL when both servers are running.

Gab · Accepted Answer · 2017-03-15 00:40:19Z

0

pg_hba.conf.txt has to be called pg_hba.conf.

Beyond this, when you have en authentication error you will get a message similar to:

psql -U nonexistent
psql: FATAL:  Peer authentication failed for user "nonexistent"

The error you are getting means most likely that PostgreSQL is not started on this server.

You can start PostgreSQL with:

service postgresql start
service postgresql status

answered Mar 15, 2017 at 0:40

Gab

3,5381 gold badge13 silver badges23 bronze badges

1 Comment

DarksteelPenguin Over a year ago

psql -U myuser -d mydatabase works fine, I did start the service and statusshows it as active. But I still get that Connection refused error.

Karthik Sagar · Accepted Answer · 2018-02-19 11:53:41Z

0

This worked for me -

In C:\Program Files\PostgreSQL\data\postgresql.conf set listen_addresses ='localhost'

Then try -

pg_ctl -D "C:\Program Files\PostgreSQL\9.5\data" start

if already try restarting using pg_ctl

answered Feb 19, 2018 at 11:53

Karthik Sagar

4444 silver badges8 bronze badges

Comments

Kairat Koibagarov · Accepted Answer · 2020-03-17 05:41:51Z

0

It works for me. Remember, whatever comes after -D should be the path to where you installed PostgreSQL, to the data folder, which holds the pg_hba.conf and postgresql.conf files.

pg_ctl start -D "C:/Program Files/PostgreSQL/9.6/data"

answered Mar 17, 2020 at 5:41

Kairat Koibagarov

1,52516 silver badges9 bronze badges

Comments

Dharman · Accepted Answer · 2022-05-05 08:44:04Z

0

Maybe you can try this. Open cmd and insert.

"C:\Program Files\PostgreSQL\11\bin\pg_ctl.exe" runservice -N "postgresql-x64-11" -D "C:\Program Files\PostgreSQL\11\data" -w

Hit enter...

edited May 5, 2022 at 8:44

Dharman♦

33.9k27 gold badges103 silver badges156 bronze badges

answered May 24, 2019 at 12:15

Yan LimaBenua

8511 bronze badges

Collectives™ on Stack Overflow

PostgreSQL Connection Refused

6 Answers 6

1 Comment

1 Comment

1 Comment

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

1 Comment

1 Comment

Comments

Comments

Comments

Linked

Related