MIME-Version: 1.0
References: <CAADeyWjQNmfiQxaiRF0tkZ-kZyApPJT00xbmcMtj+oToSPGoWQ@mail.gmail.com>
 <056ebaa8-94bb-461d-905c-4035eab9ceac@aklaver.com>
In-Reply-To: <056ebaa8-94bb-461d-905c-4035eab9ceac@aklaver.com>
From: Alexander Farber <alexander.farber@gmail.com>
Date: Thu, 27 Feb 2025 19:14:25 +0100
Message-ID: <CAADeyWjAUV8q_gdmEA=G4H5b66gaZopp42bTch27okCxPTS=hQ@mail.gmail.com>
Subject: Re: How to debug: password authentication failed for user
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a9521b062f23a928"
Archived-At: <https://www.postgresql.org/message-id/CAADeyWjAUV8q_gdmEA%3DG4H5b66gaZopp42bTch27okCxPTS%3DhQ%40mail.gmail.com>
Precedence: bulk

--000000000000a9521b062f23a928
Content-Type: text/plain; charset="UTF-8"

That seems to be the reason, thank you Adrian.

At first connecting from the other pod in the AKS cluster does not work:

$ PGPASSWORD=timeshift_pass psql --host=timeshiftservice --port=5432
--dbname=timeshift_database --username=timeshift_user
psql: error: connection to server at "timeshiftservice" (10.0.120.194),
port 5432 failed: FATAL:  password authentication failed for user "t
imeshift_user"

But once I connect to my PostgreSQL pod (or is it called "container"? I am
always confused by that) and run locally

$ psql -U postgres
psql (17.4)
Type "help" for help.

timeshift_database=# ALTER ROLE timeshift_user PASSWORD 'timeshift_pass';
ALTER ROLE

Then the connection from the other pod works immediately

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

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">That seems to be the rea=
son, thank you Adrian.<br><br>At first connecting from the other pod in the=
 AKS cluster does not work:<br><br><div>$ PGPASSWORD=3Dtimeshift_pass psql =
--host=3Dtimeshiftservice --port=3D5432 --dbname=3Dtimeshift_database --use=
rname=3Dtimeshift_user</div><div>psql: error: connection to server at &quot=
;timeshiftservice&quot; (10.0.120.194), port 5432 failed: FATAL:=C2=A0 pass=
word authentication failed for user &quot;t</div><div>imeshift_user&quot;</=
div><div><br>But once I connect to my PostgreSQL pod (or is it called &quot=
;container&quot;? I am always confused by that) and run locally<br><br><div=
>$ psql -U postgres</div><div>psql (17.4)</div><div>Type &quot;help&quot; f=
or help.</div><div><br></div><div>timeshift_database=3D# ALTER ROLE timeshi=
ft_user PASSWORD &#39;timeshift_pass&#39;;</div><div>ALTER ROLE</div></div>=
<div><br>Then the connection from the other pod works immediately</div><br>=
<br><br></div></div></div>

--000000000000a9521b062f23a928--