Re: tool to migrate database

2021-04-29 Thread silvio brandani 
 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 
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  https://momjian.us
>   EDB  https://enterprisedb.com
>
>   If only the physical world exists, free will is an illusion.
>
>
>
>
>
>

Re: tool to migrate database

2021-03-23 Thread Bruce Momjian 
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  https://momjian.us
  EDB  https://enterprisedb.com

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

Re: tool to migrate database

2021-03-23 Thread Joel Jacobson 
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:

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.

Best regards,

Joel

tool to migrate database

2021-03-23 Thread isabelle Ross 
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


Mail
priva di virus. www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>