Postgresql localhost connection - Connection refused

Question

i just installed pgadmin iii and try to connect server.

I configured my setting

name:localhost
host: 127.0.0.1
port:5432

username:postgres

but i always get this error

The server doesn't accept connection: the connection library reports **could not connect to server : Connection refused Is server runing on host "127.0.0.1" and accepting TCP/IP connections on port 5432?

However, i'm runing django and python on 127.0.0.1 What's missing?

There's also a problem with mysql. I could not connect with them

Have you checked if postgresql actually runs?

rantanplan
– rantanplan

2012-05-30 20:25:24 +00:00
Commented May 30, 2012 at 20:25 — rantanplan
– rantanplan, Commented May 30, 2012 at 20:25

Cezar Romaniuc · Accepted Answer · 2012-05-30 20:31:00Z

6

If you change the pg_hba.conf file to accept connections (for example: "host all all 127.0.0.1 255.255.255.0 trust") it should work

answered May 30, 2012 at 20:31

Cezar Romaniuc

761 bronze badge

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

Comments

Karl Fjellstrom · Accepted Answer · 2019-11-06 14:19:18Z

0

Installing postgre v12 before uninstalling v11 I found the config file (postgresql.conf) had a line "port = 5433". Changing this to "port = 5432" fixed the issue for me.

answered Nov 6, 2019 at 14:19

Karl Fjellstrom

12 bronze badges

Collectives™ on Stack Overflow

Postgresql localhost connection - Connection refused

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related