4 ms·
Re upgrades, have you tried pg_upgrade for upgrades in place? Re enums, we had a similar thing and simply went with a smallint column instead of enum.
by yardstick 7y ago
Re upgrades, have you tried pg_upgrade for upgrades in place?
Re enums, we had a similar thing and simply went with a smallint column instead of enum.
- yjftsjthsd-h 7y ago> Re upgrades, have you tried pg_upgrade for upgrades in place? This only works when you have both versions available at the same time, which seems likely to break when a package manager jumps major versions, and also doesn't work when running postgres in Docker (https://github.com/docker-library/postgres/issues/37 https://github.com/docker-library/postgres/issues/37).
- nasalgoat 7y agoI've found that it's incompatible with the PostGIS extension due to version differences. I'm still on 9.5 because I can't afford the downtime to properly migrate.