Hacker News new | ask | show | jobs
by sufehmi 2955 days 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
1 comments
manquer 2955 days ago
You 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.
link
sufehmi 2955 days ago
Great idea - I'll try to see if this is doable in our situation. Thanks.
link