Search Postgresql Archives

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

Subject: Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
From: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Mon, 2 Dec 2024 12:24:21 +0100
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAADeyWg4YwL=EH+ctP5r1frWBv+pEMwx8JwQdK+_VjLz=H9iOw@mail.gmail.com>
References: <CAADeyWiW+Uz5z_RJrB=dhWoZAOngQ2dHQt+2UOGJiEv6pbcDCA@mail.gmail.com> <1454490.1733083127@sss.pgh.pa.us> <CAADeyWiWpQmcBPKtpSrmh0ZkyE3tpX-JTSr2UcBX-gO53ZM4TQ@mail.gmail.com> <CAADeyWhF5nXZY-7HHvGUxJ-fgq7rKgCYKcGrE6X_OuX+g3xb_Q@mail.gmail.com> <CAADeyWjY=6eOGxW4V_vVS8d1jm+Lz-GPYs3ViogWZfujoWws6A@mail.gmail.com> <CAP8Hi7K4_62WCo4W852je7p8Vv+v2-dduJxSJCvtg27j1=jtvA@mail.gmail.com> <CAADeyWg4YwL=EH+ctP5r1frWBv+pEMwx8JwQdK+_VjLz=H9iOw@mail.gmail.com>

Hi again, I would like to share a slightly better workaround
(does not restart PostgreSQL) for enabling localhost connections

(for example for servlets) in a postgres:17-alpine3.20 based Dockerfile:

RUN sed -i "s/listen_addresses=''/listen_addresses='localhost'/" /usr/local/bin/docker-entrypoint.sh

References:
- Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
  - From: Alexander Farber
- Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
  - From: Tom Lane
- Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
  - From: Alexander Farber
- Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
  - From: Alexander Farber
- Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
  - From: Alexander Farber
- Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
  - From: Peter Kleiner
- Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
  - From: Alexander Farber