On Mon, Mar 22, 2021, at 22:47, isabelle Ross wrote:
>Hi,
>I'm looking for a software to migrate database between versions with minimum downtime.
>
>which one can be used to do this job ?
Hi Isabelle,
There are multiple ways to do it.
The fastest way is probably pg_upgrade.
There are some difference ways to do it depending on what requirements you have on redundancy while upgrading.
I recently read an interesting real-life story from a very big company, Adyen, and how they upgraded their 50 terrabyte PostgreSQL database. The article is from 2018 but I still think it's relevant:
There might be other good tools I don't know of, I'm not an expert on upgrades.
Hopefully other pghackers can fill in.
Best regards,
Joel