MIME-Version: 1.0
In-Reply-To: <19537-a8c72b8459700bfb@postgresql.org>
References: <19537-a8c72b8459700bfb@postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 27 Jun 2026 08:32:59 -0700
Message-ID: 
 <CAKFQuwb3Qy4aq0CwdswT6bE3DR=YyNn8dLtxMRA3VT4ZNWe5vQ@mail.gmail.com>
Subject: Re: BUG #19537: Authentication failed regardless of typing exactly my
 password set from sudo passwd postgres
To: "joshcabara22@gmail.com" <joshcabara22@gmail.com>,
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d2ecb706553df04e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwb3Qy4aq0CwdswT6bE3DR%3DYyNn8dLtxMRA3VT4ZNWe5vQ%40mail.gmail.com>
Precedence: bulk

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

On Friday, June 26, 2026, PG Bug reporting form <noreply@postgresql.org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19537
> Logged by:          JOSHUA CABANILLAS
> Email address:      joshcabara22@gmail.com
> PostgreSQL version: 18.4
> Operating system:   Ubuntu 26.04 LTS
> Description:
>
> So I just gave up on trying to fix it for my own and followed through this
> forum to submit it as a bug report.
> Any guidance for fixing this error will be appreciated.
>
>
The bug report form is not the place to obtain help using the product.  The
-general mailing list or other community resources like Slack and Discord
are.

That said, the password you need to supply when logging into PostgreSQL is
whatever password the database has recorded for the user in question.  The
operating system password is not relevant.

There are quite a few guides out there explaining how the PostgreSQL
authentication works on Linux. (The docs are a bit more generic.)  One
thing to note - usually you want to keep the postgres user authenticating
via peer authentication.  Removing pgAdmin from the stack for the moment
and getting everything working using psql is also advised.

David J.

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

On Friday, June 26, 2026, PG Bug reporting form &lt;<a href=3D"mailto:norep=
ly@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex">The following bug has been logged on the website:<br>
<br>
Bug reference:=C2=A0 =C2=A0 =C2=A0 19537<br>
Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 JOSHUA CABANILLAS<br>
Email address:=C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:joshcabara22@gmail.com=
">joshcabara22@gmail.com</a><br>
PostgreSQL version: 18.4<br>
Operating system:=C2=A0 =C2=A0Ubuntu 26.04 LTS<br>
Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>
<br>So I just gave up on trying to fix it for my own and followed through t=
his<br>
forum to submit it as a bug report.<br>
Any guidance for fixing this error will be appreciated.<br><br>
</blockquote><div><br></div><div>The bug report form is not the place to ob=
tain help using the product.=C2=A0 The -general mailing list or other commu=
nity resources like Slack and Discord are.</div><div><br></div><div>That sa=
id, the password you need to supply when logging into PostgreSQL is whateve=
r password the database has recorded for the user in question.=C2=A0 The op=
erating system password is not relevant.</div><div><br></div><div>There are=
 quite a few guides out there explaining how the PostgreSQL authentication =
works on Linux. (The docs are a bit more generic.) =C2=A0One thing to note =
- usually you want to keep the postgres user authenticating via peer authen=
tication.=C2=A0 Removing pgAdmin from the stack for the moment and getting =
everything working using psql is also advised.</div><div><br></div><div>Dav=
id J.</div><div><br></div>

--000000000000d2ecb706553df04e--