PostgreSQL on Docker
2023-05-31 - psic4t
Running Postgres on Docker is easy. Upgrading major versions is not. Some useful commands:
Running psql docker exec -it postgrespostgres1 psql -U postgres databasename
Dump everything in a gzipped file
Upgrade major version
This is tricky. I use this:
docker run --rm -v /data/postgres:/var/lib/postgresql tianon/postgres-upgrade:14-to-15 --link
You need to have your data in the following stucture: /data/postgres/14/data (old version) /data/postgres/15/data (new version will be linked here)