diff options
| author | breadcat | 2023-11-13 19:36:41 +0000 |
|---|---|---|
| committer | breadcat | 2023-11-13 19:36:41 +0000 |
| commit | 9ff847ae93198d4d3c15ada6b62c14d433d1e83a (patch) | |
| tree | f3dda605de418b69a7e0525edfab914474f76aa8 /content/posts | |
| parent | 5ff0e6cf69aadfe078fcdd026a0b2dad9d946329 (diff) | |
| download | blog.minskio.co.uk-9ff847ae93198d4d3c15ada6b62c14d433d1e83a.tar.gz blog.minskio.co.uk-9ff847ae93198d4d3c15ada6b62c14d433d1e83a.tar.bz2 blog.minskio.co.uk-9ff847ae93198d4d3c15ada6b62c14d433d1e83a.zip | |
Update postgresql post
Diffstat (limited to 'content/posts')
| -rw-r--r-- | content/posts/upgrading-postgresql-docker-containers.md | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/content/posts/upgrading-postgresql-docker-containers.md b/content/posts/upgrading-postgresql-docker-containers.md index fd8a459..aab88d7 100644 --- a/content/posts/upgrading-postgresql-docker-containers.md +++ b/content/posts/upgrading-postgresql-docker-containers.md @@ -51,4 +51,18 @@ docker logs -f postgres All being well, everything will have gone well and you can bookmark this guide for the next major upgrade. -* **Edit 2023-02-14:** Streamlined restoration instructions
\ No newline at end of file +## SCRAM error + +During my most recent upgrade (and subsequent check of this guide) I encountered an issue where the password encryption method was too old and the container wouldn't boot. To solve this, it's reasonably straightforward. You just need to rehash your password with the following: + +``` +docker exec -it postgres sh +psql -U postgres +\password yourexistingSQLpassword +exit +exit +docker restart postgres +``` + +* **Edit 2023-02-14:** Streamlined restoration instructions +* **Edit 2023-09-21:** SCRAM password encryption instructions added |