Logical Replication: Initial Snapshot For Large DB

From: Tim <timfosho(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Logical Replication: Initial Snapshot For Large DB
Date: 2021-03-10 02:24:00
Message-ID: CAKhLO5hEYM7dknPfhy6-FAee7L1_SebvjZ+yLiuXTFMud+W1aw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,

I have a pretty large HA database (2TB) that I need to migrate from EDB
Advanced Server 12 to standard Postgres (12 or 13 doesn't matter).
According to the docs, in Logical replication an initial snapshot happens
in order to synchronize a publisher and subscriber. Will this initial
snapshot work between 2 different versions of Postgres? If it would work,
what sort of system load can I expect for 2TBs of data? The goal is to have
0 downtime, other than the switchover to master on the new version. Also,
besides the initial snapshot is there any other way to incrementally seed
the subscriber DB over a period of time?

Thank you!

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-03-10 08:14:46 Re: Lock after several failed login attempts
Previous Message Holger Jakobs 2021-03-09 20:45:32 Re: Lock after several failed login attempts