How to Upgrading dockerized postgres from 11 to 12

Yousuf 0
Viewed 37

So as the title says i have a dockerized postgres database on a rails app. I'm just wondering how i'd go about upgrading the postgres version. I haven't done any upgrade work before so I don't want to lose data.

docker-compose file

  postgres:
    image: postgres:11.5
    ports:
      - "5432:5432"
    volumes:
      - postgres_data:/var/lib/postgresql/data
    env_file:
      .docker.env
postgresql docker-compose docker
1 Answers

You can use pg_dumpall command for upgrading e.g. 11.x to 12.x:

  1. Backup your old database
docker exec -it <your-old-postgres-container-id> /usr/bin/pg_dumpall -U <postgres-username> backupfile   #postgres-username='postgres'
  1. Start new container with new Postgres version (Note! with new volume mount)
  2. Import backuped file into new container
ocker exec -it <new-postgres-container-id> psql < backupfile
  1. Stop old container and verify Import in new container
m19v0
Related