4 ms·
What about upgrading to a newer version of PostgreSQL ? Does that still require upgrading the whole databases ? I evaluated PostgreSQL several times in the pas
by sufehmi 8y ago
What about upgrading to a newer version of PostgreSQL ? Does that still require upgrading the whole databases ?
I evaluated PostgreSQL several times in the past, and cancelled once I found out that upgrading to a new version requires upgrading the whole databases - our databases are too big and our uptime requirement are too strict, we can not afford it
- manquer 8y agoYou can use logical replication between 2 versions and fail over to the new version without any downtime . In pg 10+ it is built into core, for earlier versions you can use pglogical or similar tools.
- sufehmi 8y agoGreat idea - I'll try to see if this is doable in our situation. Thanks.