Upgrade Postgresql From 13 to 15 with Docker

Pastikan sudah menginstall Docker dan Docker Compose pada Instance.

$ mkdir -p postgres-upgrade-testing

$ cd postgres-upgrade-testing

$ OLD='13'

$ NEW='15'

$ docker pull "postgres:$OLD"

$ docker run -dit \

--name postgres-upgrade-testing \

-e POSTGRES_PASSWORD=password \

-v "$PWD/$OLD/data":/var/lib/postgresql/data \

"postgres:$OLD"

$ sleep 5

$ docker logs --tail 100 postgres-upgrade-testing

$ # let's get some testing data in there

$ docker exec -it \

-u postgres \

postgres-upgrade-testing \

pgbench -i -s 10

$ docker stop postgres-upgrade-testing

$ docker rm postgres-upgrade-testing

$ docker run --rm \

-v "$PWD":/var/lib/postgresql \

"tianon/postgres-upgrade:$OLD-to-$NEW" \

--link

$ docker pull "postgres:$NEW"

$ docker run -dit \

--name postgres-upgrade-testing \

-e POSTGRES_PASSWORD=password \

-v "$PWD/$NEW/data":/var/lib/postgresql/data \

"postgres:$NEW"

$ sleep 5

$ docker logs --tail 100 postgres-upgrade-testing

$ # can now safely remove "$OLD"

$ sudo rm -rf "$OLD"