Re: BUG #19537: Authentication failed regardless of typing exactly my password set from sudo passwd postgres

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "joshcabara22(at)gmail(dot)com" <joshcabara22(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19537: Authentication failed regardless of typing exactly my password set from sudo passwd postgres
Date: 2026-06-27 15:32:59
Message-ID: CAKFQuwb3Qy4aq0CwdswT6bE3DR=YyNn8dLtxMRA3VT4ZNWe5vQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Friday, June 26, 2026, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 19537
> Logged by: JOSHUA CABANILLAS
> Email address: joshcabara22(at)gmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Chengpeng Yan 2026-06-27 16:53:37 Re: BUG #19533: Wrong results from WindowAgg run-condition pushdown on count() with EXCLUDE CURRENT ROW
Previous Message Michael Paquier 2026-06-27 02:50:05 Re: Set huge_page_size on 32bit system