MIME-Version: 1.0
References: <CAADeyWiW+Uz5z_RJrB=dhWoZAOngQ2dHQt+2UOGJiEv6pbcDCA@mail.gmail.com>
 <1454490.1733083127@sss.pgh.pa.us>
In-Reply-To: <1454490.1733083127@sss.pgh.pa.us>
From: Alexander Farber <alexander.farber@gmail.com>
Date: Sun, 1 Dec 2024 21:36:28 +0100
Message-ID: <CAADeyWiWpQmcBPKtpSrmh0ZkyE3tpX-JTSr2UcBX-gO53ZM4TQ@mail.gmail.com>
Subject: Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009c3c3706283b6371"
Archived-At: <https://www.postgresql.org/message-id/CAADeyWiWpQmcBPKtpSrmh0ZkyE3tpX-JTSr2UcBX-gO53ZM4TQ%40mail.gmail.com>
Precedence: bulk

--0000000000009c3c3706283b6371
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you, Tom -

On Sun, Dec 1, 2024 at 8:58=E2=80=AFPM 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=3D> show listen_addresses;
 listen_addresses
------------------

(1 row)

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

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

--0000000000009c3c3706283b6371
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Thank y=
ou, Tom -</div><br><div class=3D"gmail_quote gmail_quote_container"><div di=
r=3D"ltr" class=3D"gmail_attr">On Sun, Dec 1, 2024 at 8:58=E2=80=AFPM Tom L=
ane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrot=
e:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Alexander Far=
ber &lt;<a href=3D"mailto:alexander.farber@gmail.com" target=3D"_blank">ale=
xander.farber@gmail.com</a>&gt; writes:<br>
&gt; TLDR &quot;psql words_de&quot; works, but &quot;psql -h localhost word=
s_de&quot; does not<br>
<br>
I&#39;d try connecting the first way and seeing what &quot;show<br>
listen_addresses&quot; gives.=C2=A0 Per your report it should be &quot;*&qu=
ot;,<br>
but maybe something is overriding that.<br>
<br>
If it is &quot;*&quot;, then it seems like something is interfering with<br=
>
expanding that.=C2=A0 Maybe try explicitly setting it to &quot;localhost&qu=
ot;?<br></blockquote><div><br>it is empty in my docker container (but &quot=
;localhost&quot; on my prod server), <br>so I probably need to investigate =
that...<br><br><div>$ psql words_de</div><div>psql (17.2)</div><div>Type &q=
uot;help&quot; for help.</div><div><br></div><div>words_de=3D&gt; show list=
en_addresses;</div><div>=C2=A0listen_addresses=C2=A0</div><div>------------=
------</div><div>=C2=A0</div><div>(1 row)</div><div><br></div><div>words_de=
=3D&gt; set listen_addresses=3D&#39;localhost&#39;;</div><div>ERROR:=C2=A0 =
parameter &quot;listen_addresses&quot; cannot be changed without restarting=
 the server<br><br><div># grep listen_addresses $PGDATA/postgresql.conf</di=
v><div>listen_addresses =3D &#39;*&#39;<br><br><br></div></div></div></div>=
</div></div></div>

--0000000000009c3c3706283b6371--