minimal tech for today

PostgreSQL on Docker

2023-05-31 - psic4t

Running Postgres on Docker is easy. Upgrading major versions is not. Some useful commands:

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)

View more postsRSS