Hacker News new | ask | show | jobs
by andruby 1859 days ago
Pg_upgrade [0] is an official part of postgres and does the binary inplace upgrade for you. You should obviously test before running in production, but it has worked perfectly for us when upgrading a 10+TB cluster from pg11 to pg13

[0] https://www.postgresql.org/docs/current/pgupgrade.html
1 comments
conradfr 1859 days ago
Not totally ideal if you're using containers as it requires the binaries of the old and new version, unless I'm missing something.
link
pgaddict 1859 days ago
That's hardly a PostgreSQL issue. If your container tech does not allow installing both old and new version of the binaries, it's a silly container tech.
link
conradfr 1859 days ago
Well I use the official Postgresql docker image ;)

Also it looks like this is not new https://github.com/docker-library/postgres/issues/37

link
Apaec 1859 days ago
Note that the "official" PostgreSQL docker image is maintained by Docker Inc - not by PostgreSQL contributors/members.
link
salmo 1859 days ago
Containerized DBs are great for dev work, toy projects, etc.

Notsomuch for production. I know... folks do it. But I wouldn't run anything on it that I wouldn't do w/ sqlite.

link
golergka 1858 days ago
Why not? Having the whole application in one Kubernetes setup, with all databases and other services is very convenient. Are you talking about performance overhead, or are there other drawbacks to this approach?
link
randomswede 1858 days ago
The main problem is "persistent storage". In k8s, a PVC/PV is probably close to the right answer, but in general that gives you a file-system view of the storage, not a block-device view, which for some databases might matter).

Also, in general, that persistent storage is (generally) not locally attached, which means that (some) file system interactions may have unexpected semantics. Now, with a DB, you're probably only going to have the PV attached on a single worker node, so most of that will actually just work.

link
ComputerGuru 1859 days ago
It does not make sense to run a rdbms in a container in prod; the entire OS is your container.
link
conradfr 1857 days ago
It makes sense for me using CapRover for my side projects (with multiple envs) all in one cheap server.
link
megous 1859 days ago
All distros I've ever used (debian, arch) provide previous and current version of postgresql for the purpose of easy pg_upgrade.

Debian even has special custom helper scripts for doing it. So just build your container with both postgres versions?

link