Postgres connection issue

Question

I installed and started my Postgres database with brew (on my Mac). I also defined an entry in my /etc/hosts file (I tried both with 127.0.0.1 postgres and with postgres).

However, when I try

psql -h postgres -U postgres -p 5432

I cannot connect

psql: could not connect to server: Connection refused.

However, when I try with

psql -h localhost -U postgres -p 5432

I can connect. What is needed to be able to connect with: psql -h postgres -U postgres -p 5432

Looks like your hosts file is wrong. Can you ping to postgres? — Paco Abato
– Paco Abato, Commented Sep 11, 2019 at 13:10
I guess this is an OS-related question, not a PSQL-related one. If your system resolves the address postgres to localhost, you should be able to connect in such way. — Islingre
– Islingre, Commented Sep 11, 2019 at 13:11

Pablo Santa Cruz · Accepted Answer · 2019-09-11 13:17:14Z

1

Make sure your PostgreSQL server is willing to accept tcp/ip connections on port 5432.

In your PostgreSQL configuration file check these values.

listen_addresses = '*'
port = 5432

answered Sep 11, 2019 at 13:17

Pablo Santa Cruz

182k33 gold badges250 silver badges300 bronze badges

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

1 Comment

Christian68 Over a year ago

Thanks - that enabled me to connect with either postgres or localhost as the hostname.

Collectives™ on Stack Overflow

Postgres connection issue

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related