Skip to content

Upgrade PostgreSQL from 11 to 12 with keeping support of 9.6

Takuya Noguchi requested to merge 43-upgrade-to-postgresql-12 into master

Upgrades PostgreSQL from 11 to 12 with keeping support of 9.6.

Testing

Command line

make create-dev
# [...]
make env
docker tag registry.gitlab.com/ayufan/gitlab-compose-kit/releases:postgres-7050e3d63470a905f797123c55164760df3ec2cb{,-bak}
docker rmi -f registry.gitlab.com/ayufan/gitlab-compose-kit/releases:postgres-7050e3d63470a905f797123c55164760df3ec2cb registry.gitlab.com/gitlab-org/gitlab-compose-kit/releases:7050e3d63470a905f797123c55164760df3ec2cb
(cd ./dockerfiles/postgres; docker build -t registry.gitlab.com/ayufan/gitlab-compose-kit/releases:postgres-12 .)
(cd ./dockerfiles; docker build -t registry.gitlab.com/ayufan/gitlab-compose-kit/releases:12 .)
make down
docker-compose up --build

Web UI

#43[localhost_3000_admin.png]

Image size

Due to as large postgres:12-alpine image size as postgres:11-alpine compared to 9-alpine, the local docker image would be +120MB than before as follows:

registry.gitlab.com/ayufan/gitlab-compose-kit/releases       postgres-7050e3d63470a905f797123c55164760df3ec2cb       465b07a630eb        26 minutes ago      315MB
registry.gitlab.com/ayufan/gitlab-compose-kit/releases       postgres-7050e3d63470a905f797123c55164760df3ec2cb-bak   3852d9c7d7f0        6 hours ago         194MB

cf.

REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
postgres            9-alpine            4bb112d23234        6 days ago          37.6MB
postgres            11-alpine           29ed0d79c08b        6 days ago          157MB
postgres            12-alpine           47aa97c69678        6 days ago          159MB

Closes #43 (closed)

Edited by Takuya Noguchi

Merge request reports