MIME-Version: 1.0
References: <CAADeyWjTfKCyDusy1biPAWmhJWh+9hSNrm219uV7UM7UnmaJ8Q@mail.gmail.com>
 <CAADeyWh+6HtWaa8ctVD_PPcBEwS=qYSkYqkQh8JV=wAYBots3Q@mail.gmail.com> <CAADeyWgaHUvVfhyE9dWyGjzkNB_RkK4iQNmoHSZkEt-w=hfEVg@mail.gmail.com>
In-Reply-To: <CAADeyWgaHUvVfhyE9dWyGjzkNB_RkK4iQNmoHSZkEt-w=hfEVg@mail.gmail.com>
From: Alicja Kucharczyk <zaledwie10minut@gmail.com>
Date: Fri, 28 Feb 2025 16:16:38 +0100
Message-ID: <CAM=sWa4UjaS0U9yYJKx-P7=V=8ZPJJSCSQ0xqZfMzmvp11Zbpw@mail.gmail.com>
Subject: Re: Azure Database for PostgreSQL flexible server: password
 authentication failed
To: Alexander Farber <alexander.farber@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a1ce90062f354b92"
Archived-At: <https://www.postgresql.org/message-id/CAM%3DsWa4UjaS0U9yYJKx-P7%3DV%3D8ZPJJSCSQ0xqZfMzmvp11Zbpw%40mail.gmail.com>
Precedence: bulk

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

Hi Alex,

pt., 28 lut 2025 o 16:05 Alexander Farber <alexander.farber@gmail.com>
napisa=C5=82(a):

> Now the connection from a container in AKS works for me:
>
> $ psql "postgresql://postgresql:password12345!!@
> 172.21.32.4:5432/postgres?sslmode=3Drequire"
> psql (17.4, server 16.6)
> SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384,
> compression: off, ALPN: none)
> Type "help" for help.
>
> postgres=3D>
>

good it finally worked ;)


>
> I must find now how to add a non-super user to it next.
>
You are adding users there as in any other postgres instance, just use
CREATE ROLE/USER from SQL prompt or use createuser utility.

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

<div dir=3D"ltr"><div dir=3D"ltr">Hi Alex,</div><br><div class=3D"gmail_quo=
te gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">pt., 28 lut=
 2025 o 16:05=C2=A0Alexander Farber &lt;<a href=3D"mailto:alexander.farber@=
gmail.com">alexander.farber@gmail.com</a>&gt; napisa=C5=82(a):</div><blockq=
uote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1p=
x solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr=
"><div dir=3D"ltr">Now the connection from a container in AKS works for me:=
<br><br><div dir=3D"ltr">$ psql &quot;postgresql://postgresql:password12345=
!!@<a href=3D"http://172.21.32.4:5432/postgres?sslmode=3Drequire" target=3D=
"_blank">172.21.32.4:5432/postgres?sslmode=3Drequire</a>&quot;</div><div di=
r=3D"ltr">psql (17.4, server 16.6)</div><div dir=3D"ltr">SSL connection (pr=
otocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off, ALPN: no=
ne)</div><div dir=3D"ltr">Type &quot;help&quot; for help.</div><div dir=3D"=
ltr">=C2=A0</div><div dir=3D"ltr">postgres=3D&gt;<br></div></div></div></di=
v></blockquote><div><br></div><div>good it finally worked ;)</div><div>=C2=
=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"=
><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><br>I must find now how=
 to add a non-super user to it next.<br></div></div></div></div></blockquot=
e><div>You are adding users there as in any other postgres instance, just u=
se CREATE ROLE/USER from SQL prompt or use createuser utility.</div></div><=
/div>

--000000000000a1ce90062f354b92--