jackblk / config

my config
0 stars 0 forks source link

Fix SCRAM secret missing when upgrading PostgreSQL from to >=14 #33

Open jackblk opened 3 months ago

jackblk commented 3 months ago

This should generate a new SCRAM secret for the old password.

docker exec -it postgres bash
psql -U postgres
ALTER ROLE postgres WITH PASSWORD 'same_old_password';

https://stackoverflow.com/questions/64210167/unable-to-connect-to-postgres-db-due-to-the-authentication-type-10-is-not-suppor