Re: tool to migrate database
| От | Joel Jacobson |
|---|---|
| Тема | Re: tool to migrate database |
| Дата | |
| Msg-id | 3002308f-2ec4-4b43-ad25-5933a4d8f8d9@www.fastmail.com обсуждение исходный текст |
| Ответ на | tool to migrate database (isabelle Ross <mktg.ide@gmail.com>) |
| Ответы |
Re: tool to migrate database
|
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: