Thread: tool to migrate database
Hi,
I'm looking for a software to migrate database between versions with minimum downtime.
which one can be used to do this job ?
thanks
Isabelle
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
On Tue, Mar 23, 2021 at 09:49:57AM +0100, Joel Jacobson wrote: > 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: > > https://medium.com/adyen/ > updating-a-50-terabyte-postgresql-database-f64384b799e7 > > There might be other good tools I don't know of, I'm not an expert on upgrades. > Hopefully other pghackers can fill in. This is not an appropriate topic for the hackers email list, which is for internal server development discussion. The 'general' or 'admin' lists would be better. -- Bruce Momjian <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
concepts similar and related to migration/replication are applied with the software tcapture , please give a look at https://www.tcapture.net/
Il giorno gio 29 apr 2021 alle ore 16:34 Bruce Momjian <bruce@momjian.us> ha scritto:
On Tue, Mar 23, 2021 at 09:49:57AM +0100, Joel Jacobson wrote:
> 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:
>
> https://medium.com/adyen/
> updating-a-50-terabyte-postgresql-database-f64384b799e7
>
> There might be other good tools I don't know of, I'm not an expert on upgrades.
> Hopefully other pghackers can fill in.
This is not an appropriate topic for the hackers email list, which is
for internal server development discussion. The 'general' or 'admin'
lists would be better.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.