Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 - Mailing list pgsql-general

From Alexander Farber
Subject Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
Date
Msg-id CAADeyWiWpQmcBPKtpSrmh0ZkyE3tpX-JTSr2UcBX-gO53ZM4TQ@mail.gmail.com
Whole thread Raw
In response to Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
List pgsql-general
Thank you, Tom -

On Sun, Dec 1, 2024 at 8:58 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Alexander Farber <alexander.farber@gmail.com> writes:
> TLDR "psql words_de" works, but "psql -h localhost words_de" does not

I'd try connecting the first way and seeing what "show
listen_addresses" gives.  Per your report it should be "*",
but maybe something is overriding that.

If it is "*", then it seems like something is interfering with
expanding that.  Maybe try explicitly setting it to "localhost"?

it is empty in my docker container (but "localhost" on my prod server),
so I probably need to investigate that...

$ psql words_de
psql (17.2)
Type "help" for help.

words_de=> show listen_addresses;
 listen_addresses 
------------------
 
(1 row)

words_de=> set listen_addresses='localhost';
ERROR:  parameter "listen_addresses" cannot be changed without restarting the server

# grep listen_addresses $PGDATA/postgresql.conf
listen_addresses = '*'


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Errors when restoring backup created by pg_dumpall
Next
From: Alexander Farber
Date:
Subject: Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20