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!
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 |