public inbox for [email protected]
help / color / mirror / Atom feedBUG #19537: Authentication failed regardless of typing exactly my password set from sudo passwd postgres
2+ messages / 2 participants
[nested] [flat]
* BUG #19537: Authentication failed regardless of typing exactly my password set from sudo passwd postgres
@ 2026-06-26 15:56 PG Bug reporting form <[email protected]>
2026-06-27 15:32 ` Re: BUG #19537: Authentication failed regardless of typing exactly my password set from sudo passwd postgres David G. Johnston <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2026-06-26 15:56 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
The following bug has been logged on the website:
Bug reference: 19537
Logged by: JOSHUA CABANILLAS
Email address: [email protected]
PostgreSQL version: 18.4
Operating system: Ubuntu 26.04 LTS
Description:
Hey, I'm using pg Admin 9.16 and have Ubuntu 26.04 LTS running as my OS.
So I tried to reinstall from scratch everything, just to see if this would
work. However, after reinstalling postgresql postgresql-contrib and pg Admin
from scratch step-by-step, and set my password and typed it exactly on the
pg Admin Register Server dialog it threw me the following error:
Unable to connect to server:
connection failed: connection to server at "127.0.0.1", port 5432 failed:
FATAL: password authentication failed for user "postgres"
connection to server at "127.0.0.1", port 5432 failed: FATAL: password
authentication failed for user "postgres"
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.
Cheers.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #19537: Authentication failed regardless of typing exactly my password set from sudo passwd postgres
2026-06-26 15:56 BUG #19537: Authentication failed regardless of typing exactly my password set from sudo passwd postgres PG Bug reporting form <[email protected]>
@ 2026-06-27 15:32 ` David G. Johnston <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2026-06-27 15:32 UTC (permalink / raw)
To: [email protected] <[email protected]>; [email protected] <[email protected]>
On Friday, June 26, 2026, PG Bug reporting form <[email protected]>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 19537
> Logged by: JOSHUA CABANILLAS
> Email address: [email protected]
> 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-06-27 15:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-06-26 15:56 BUG #19537: Authentication failed regardless of typing exactly my password set from sudo passwd postgres PG Bug reporting form <[email protected]>
2026-06-27 15:32 ` David G. Johnston <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox