Re: tool to migrate database

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Joel Jacobson <joel(at)compiler(dot)org>
Cc: isabelle Ross <mktg(dot)ide(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: tool to migrate database
Date: 2021-03-23 14:50:51
Message-ID: 20210323145051.GC579@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2021-03-23 14:55:54 Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY
Previous Message Tom Lane 2021-03-23 14:44:02 Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb