PG 14.13
--
Changed a user's expired password from user "postgres", and now that user can't log in.
I know it's something simple, but I just can't see it.
Linux server:
$ ssh -q FISPCDSPGS401A grep 11026270 '$PGDATA'/pg_hba.conf
host all 11026270 10.176.64.0/22 scram-sha-256
$ psql -h FISPCDSPGS401A
keyword | value
----------+---------------
database | postgres
user | postgres
host | 10.143.170.55
port | 5432
(4 rows)
psql (16.4, server 14.13)
Type "help" for help.
postgres=# ALTER ROLE "11026270" WITH PASSWORD 'blarge';
ALTER ROLE
postgres=# select rolpassword from pg_authid where rolname='11026270';
rolpassword
---------------------------------------------------------------------------------------------------------------------------------------
SCRAM-SHA-256$4096:x551tt4biKIvossG7VwbjA==$syOJXKLOFZ8/LHUxHq8rE5q5dCEDNzB5wgOAHq1vmdI=:q670pqidak6v8YjP9KCCWrRmfkkJSvyf/AL0Ydg1k/o=
(1 row)
Windows server:
C:\Users\11026270>psql -h FISPCDSPGS401A postgres
Password for user 11026270:
psql: error: connection to server at "FISPCDSPGS401A" (10.143.170.55), port 5432 failed: FATAL: password authentication failed for user "11026270"
$ ssh -q FISPCDSPGS401A grep 11026270 '$PGDATA'/pg_hba.conf
host all 11026270 10.176.64.0/22 scram-sha-256
$ psql -h FISPCDSPGS401A
keyword | value
----------+---------------
database | postgres
user | postgres
host | 10.143.170.55
port | 5432
(4 rows)
psql (16.4, server 14.13)
Type "help" for help.
postgres=# ALTER ROLE "11026270" WITH PASSWORD 'blarge';
ALTER ROLE
postgres=# select rolpassword from pg_authid where rolname='11026270';
rolpassword
---------------------------------------------------------------------------------------------------------------------------------------
SCRAM-SHA-256$4096:x551tt4biKIvossG7VwbjA==$syOJXKLOFZ8/LHUxHq8rE5q5dCEDNzB5wgOAHq1vmdI=:q670pqidak6v8YjP9KCCWrRmfkkJSvyf/AL0Ydg1k/o=
(1 row)
Windows server:
C:\Users\11026270>psql -h FISPCDSPGS401A postgres
Password for user 11026270:
psql: error: connection to server at "FISPCDSPGS401A" (10.143.170.55), port 5432 failed: FATAL: password authentication failed for user "11026270"
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!