3 ms·
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 w
by andruby 5y 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 https://www.postgresql.org/docs/current/pgupgrade.html
- jeffbee 5y ago10TB is basically zero. At that scale you can choose anything and get away with it.
- tinus_hn 5y ago10 tb is definitely not zero if your project is of the ‘should I choose MySQL or Postgres’ variety.
- tehbeard 5y agoHonestly this just seems like you're waving your e-peen. Care to give some more details around why and what size of disk usage cause issues for postgres / other db upgrades?
- lilSebastian 5y agoA wonderfully constructive comment that keep people using this site, or not.
- darkwater 5y agoHow can someone with 10k karma write such a statement? Were you trolling? Are you serious? 10TB of relational database can be definetly troublesome to manage and pose challenges to many organizations.
- conradfr 5y agoNot totally ideal if you're using containers as it requires the binaries of the old and new version, unless I'm missing something.
- deleted 5y ago[deleted]
- megous 5y agoAll 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?
- pgaddict 5y agoThat'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.
- conradfr 5y agoWell I use the official Postgresql docker image ;) Also it looks like this is not new https://github.com/docker-library/postgres/issues/37 https://github.com/docker-library/postgres/issues/37
- Apaec 5y agoNote that the "official" PostgreSQL docker image is maintained by Docker Inc - not by PostgreSQL contributors/members.
- salmo 5y agoContainerized 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.
- golergka 5y agoWhy 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?