Trouble upgrading PostgreSQL from 9.3 to current

installation
10

If you’re OK with some downtime, then this should work:

  1. Take and download backup
  2. ./launcher stop app
  3. docker rm app
  4. mv shared/standalone shared/standalone.9.3
  5. Edit containers/app.yml to change the postgres.9.3 to postgres
  6. ./launcher bootstrap app; ./launcher start app
  7. Import the backup

Step 4 is the step that “makes the current container cease to exist” in a meaningful sense. shared/app is where all of the PostgreSQL data, logs, etc live. By renaming it, rather than just deleting it, you’re leaving yourself with a fallback plan if the unexepected happens and everything goes to hell.

3 Likes