View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000335 | My infrastructure | General | public | 2025-11-01 13:19 | 2025-11-12 14:56 |
| Reporter | dvl | Assigned To | dvl | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | resolved | Resolution | fixed | ||
| Summary | 0000335: MD5 password support is deprecated and will be removed in a future release of PostgreSQL | ||||
| Description | From https://www.postgresql.org/docs/current/auth-password.html To upgrade an existing installation from md5 to scram-sha-256, after having ensured that all client libraries in use are new enough to support SCRAM, set password_encryption = 'scram-sha-256' in postgresql.conf, make all users set new passwords, and change the authentication method specifications in pg_hba.conf to scram-sha-256. | ||||
| Tags | No tags attached. | ||||
|
|
No errors overnight. Let's do another host. |
|
|
zuul-pg01 & zuul-pg02 are done |
|
|
These aren't available any more:[21:57 dbclone dvl ~rsyncer/backups] % ls -l tallboy/database-backup/postgresql/globals.sql -rw-r--r-- 1 rsyncer rsyncer 1330 2024.05.31 10:46 tallboy/database-backup/postgresql/globals.sql [21:57 dbclone dvl ~rsyncer/backups] % ls -l papers/database-backup/postgresql/globals.sql -rw-r--r-- 1 rsyncer rsyncer 1235 2024.06.02 16:59 papers/database-backup/postgresql/globals.sql |
|
|
Only aws-1 - but I don't see passwords in that backup. |
|
|
-- these are roles for others users to be members of. They are all nologin.template1=*# ALTER ROLE commits PASSWORD NULL; ALTER ROLE template1=*# ALTER ROLE listening PASSWORD NULL; ALTER ROLE template1=*# drop role phorum; DROP ROLE template1=*# ALTER ROLE reading PASSWORD NULL; ALTER ROLE template1=*# ALTER ROLE www PASSWORD NULL; |
|
|
Done. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-11-01 13:19 | dvl | New Issue | |
| 2025-11-01 13:19 | dvl | Status | new => assigned |
| 2025-11-01 13:19 | dvl | Assigned To | => dvl |
| 2025-11-03 21:24 | dvl | Note Added: 0000476 | |
| 2025-11-03 21:51 | dvl | Note Added: 0000477 | |
| 2025-11-03 21:58 | dvl | Note Added: 0000478 | |
| 2025-11-03 21:59 | dvl | Note Added: 0000479 | |
| 2025-11-06 20:07 | dvl | Note Added: 0000480 | |
| 2025-11-12 14:56 | dvl | Status | assigned => resolved |
| 2025-11-12 14:56 | dvl | Resolution | open => fixed |
| 2025-11-12 14:56 | dvl | Note Added: 0000492 |
