thomasstxyz/upgrade-postgres-container.md

## upgrade-postgres-container.md

      
    Raw
  

              upgrade-postgres-container.md
            
          
    Guide: Upgrade docker image postgres from 13 to 14

Pull new new images

sudo docker-compose pull

Dump database

sudo docker-compose exec [service_name_of_postgres] pg_dumpall -U [postgres_user] > /tmp/dump.sql

Shutdown old container

sudo docker-compose down

Remove old volume

sudo docker volume rm [volume_name_of_postgres_data]

Start new container

sudo docker-compose up -d

Copy dump file into new volume

sudo cp /tmp/dump.sql /var/lib/docker/volumes/[volume_name_of_postgres_data]/_data/

Exec into the new container

sudo docker-compose exec [service_name_of_postgres] bash

Restore dump

cd /var/lib/postgresql/data/
psql -U [postgres_user] < dump.sql

Get psql shell and set passworw

The password needs to be set because version 13 used md5 algorithm
and version 14 uses newer SCRAM-SHA-256 algorithm.
psql -U gitea
\password

# Enter the password at the prompt!

exit

exit
DONE!