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
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
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
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
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.
Hi,
We are planning to upgrade from postgres 9.5 to postgres 10, on
centos version 6.8, We have a database of around 400GBs.
We need to perform the upgrade activity with minimum downtime (around
1-2 hours). We are thinking of logical replication for the same.
but The issue is we already have co
