Re: upgrade using logical replication

2021-01-20 Thread Bruce Momjian
On Thu, Jan 21, 2021 at 10:25:39AM +0900, Ian Lawrence Barwick wrote: > 2021年1月21日(木) 9:19 Mohamed Wael Khobalatte : > > > > On Wed, Jan 20, 2021 at 2:37 PM Michael Lewis wrote: > > Using pg_upgrade takes minutes for an in place upgrade. If you can > allow 1+ hour of downti

Re: upgrade using logical replication

2021-01-20 Thread Ian Lawrence Barwick
2021年1月21日(木) 9:19 Mohamed Wael Khobalatte : > > > On Wed, Jan 20, 2021 at 2:37 PM Michael Lewis wrote: > >> Using pg_upgrade takes minutes for an in place upgrade. If you can allow >> 1+ hour of downtime, it seems overly complicated to use logical replication. >> > > I suppose the Atul's issue i

Re: upgrade using logical replication

2021-01-20 Thread Mohamed Wael Khobalatte
On Wed, Jan 20, 2021 at 2:37 PM Michael Lewis wrote: > Using pg_upgrade takes minutes for an in place upgrade. If you can allow > 1+ hour of downtime, it seems overly complicated to use logical replication. > I suppose the Atul's issue is what to do with the replicas. Once he does pg_upgrade, th

Re: upgrade using logical replication

2021-01-20 Thread Paul Förster
Hi Michael, > On 20. Jan, 2021, at 20:37, Michael Lewis wrote: > > Using pg_upgrade takes minutes for an in place upgrade. If you can allow 1+ > hour of downtime, it seems overly complicated to use logical replication. my all time best score was 18 seconds for migrating from 11 to 12. :-) Che

Re: upgrade using logical replication

2021-01-20 Thread Michael Lewis
Using pg_upgrade takes minutes for an in place upgrade. If you can allow 1+ hour of downtime, it seems overly complicated to use logical replication.