| 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.
| 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 |