0

pgadmin connection timeout

>> psql
psql: error: connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D
/10061)
        Is the server running on that host and accepting TCP/IP connections?
connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused (0x0000274D/10061)
        Is the server running on that host and accepting TCP/IP connections?

I can successfully run:

postgres --single -D "C:/Program Files/PostgreSQL/14/data"

I tried restarting the postgres-x64-16 service

5
  • Did you try looking at other answers? stackoverflow.com/questions/58588571/… Commented Mar 4 at 5:51
  • Yea I tried changing scram-sha25 method to trust in the pg_hba.conf file Commented Mar 4 at 14:42
  • If you are running two instances of Postgres on the same machine they have to be listening on different ports. Are you sure you have the 14 and 16 instances doing that? Commented Mar 4 at 16:11
  • I tried running one at a time in services, both using port 5432 Commented Mar 4 at 16:15
  • Then given this Is the server running on that host and accepting TCP/IP connections, what is listen_addresses set to in postgresql.conf? Read Connection settings for more information. Either the server is not running, it is running but not listening on port 5432 or it is not listening on the localhost interface. You need to determine which combination of those things is causing the issue. Commented Mar 4 at 16:50

1 Answer 1

0

It worked after reinstalling postgres and deleting the folder

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

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.