Postgres Pro
Downloads
Home   >   mailing lists

Re: upgrade using logical replication - Mailing list pgsql-general

From Paul Förster
Subject Re: upgrade using logical replication
Date
Msg-id 9A275C8B-6FED-4C14-8DE5-05A1494A036B@gmail.com
Whole thread Raw
In response to Re: upgrade using logical replication  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Tree view 
Hi Michael,

> On 20. Jan, 2021, at 20:37, Michael Lewis <mlewis@entrata.com> wrote:
>
> Using pg_upgrade takes minutes for an in place upgrade. If you can allow 1+ hour of downtime, it seems overly
complicatedto use logical replication. 

my all time best score was 18 seconds for migrating from 11 to 12. :-)

Cheers,
Paul

pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: upgrade using logical replication
Next
From: Michael Lewis
Date:
Subject: work_mem, temp_buffers, and temp_file_limit