Upgrade to PostgreSQL 10.13

Migration

Successfully migrated data from 9.6 to 10 by means of migration docker container.

[root@fiber ~]# su postgres
bash-4.2$ psql -h localhost
postgres=# SELECT * FROM pg_stat_activity;
postgres=# \q
bash-4.2$ exit
[root@fiber ~]# docker stop bierochs-postgres-96
[root@fiber ~]# docker run --privileged --rm --user "$(id postgres -u):$(id postgres -g)" -v /src/postgres:/var/lib/postgresql:z  -v /etc/passwd:/etc/passwd:ro tianon/postgres-upgrade:9.6-to-10 --link
[root@fiber ~]# docker pull postgres:10.13
[root@fiber ~]# docker run --name=bierochs-postgres-10 --user "$(id postgres -u):$(id postgres -g)" -d -p 5432:5432 -v /etc/passwd:/etc/passwd:ro -v /src/postgres/10/data:/var/lib/postgresql/data:z -e POSTGRES_USER=postgres  -e POSTGRES_PASSWORD=ayNVFrna postgres:10.13
[root@fiber ~]# docker rm bierochs-postgres-96

Setup

Successfully upgraded the Docker container on the Database Host by means of automated Watchtower container.
Release 10.13

Me on Mastodon - This link is here for verification purposes.