MIME-Version: 1.0
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>
In-Reply-To: <CAP8Hi7K4_62WCo4W852je7p8Vv+v2-dduJxSJCvtg27j1=jtvA@mail.gmail.com>
From: Alexander Farber <alexander.farber@gmail.com>
Date: Sun, 1 Dec 2024 22:25:54 +0100
Message-ID: <CAADeyWg4YwL=EH+ctP5r1frWBv+pEMwx8JwQdK+_VjLz=H9iOw@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="0000000000007329af06283c14dc"
Archived-At: <https://www.postgresql.org/message-id/CAADeyWg4YwL%3DEH%2BctP5r1frWBv%2BpEMwx8JwQdK%2B_VjLz%3DH9iOw%40mail.gmail.com>
Precedence: bulk

--0000000000007329af06283c14dc
Content-Type: text/plain; charset="UTF-8"

Yes thank you, I have tried specifying the port at the CLI too... that did
not help.

But restarting PostgreSQL in my
custom /docker-entrypoint-initdb.d/run-after-initdb.sh
has helped, even though I am not sure if it is the best way:

#!/bin/sh

LANGUAGES="de en fr nl pl ru"

createuser --username=postgres words

psql --username=postgres -c "GRANT USAGE ON SCHEMA public TO words;"
psql --username=postgres -c "ALTER USER words PASSWORD 'mypassword';"

for L in $LANGUAGES; do
    createdb --username=postgres --owner=words words_$L
    cd /dict/$L && psql words_$L < words_$L.sql
done

# Restart PostgreSQL to make it listen at localhost too
pg_ctl --options "-c listen_addresses='localhost'" --wait restart

--0000000000007329af06283c14dc
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"><div>Ye=
s thank you, I have tried specifying the port at the CLI too... that did no=
t help.<br><br>But restarting PostgreSQL in my custom=C2=A0/docker-entrypoi=
nt-initdb.d/run-after-initdb.sh <br>has helped, even though I am not sure i=
f it is the best way:<br><br><div>#!/bin/sh</div><div><br></div><div>LANGUA=
GES=3D&quot;de en fr nl pl ru&quot;</div><div><br></div><div>createuser --u=
sername=3Dpostgres words</div><div><br></div><div>psql --username=3Dpostgre=
s -c &quot;GRANT USAGE ON SCHEMA public TO words;&quot;</div><div>psql --us=
ername=3Dpostgres -c &quot;ALTER USER words PASSWORD &#39;mypassword&#39;;&=
quot;</div><div><br></div><div>for L in $LANGUAGES; do</div><div>=C2=A0 =C2=
=A0 createdb --username=3Dpostgres --owner=3Dwords words_$L</div><div>=C2=
=A0 =C2=A0 cd /dict/$L &amp;&amp; psql words_$L &lt; words_$L.sql</div><div=
>done</div><div><br></div><div># Restart PostgreSQL to make it listen at lo=
calhost too</div><div>pg_ctl --options &quot;-c listen_addresses=3D&#39;loc=
alhost&#39;&quot; --wait restart</div><div><br></div></div><div class=3D"gm=
ail_quote gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D=
"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-le=
ft:1ex"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex">
</blockquote></div>
</blockquote></div></div></div></div></div>

--0000000000007329af06283c14dc--