On 6/8/24 10:40, Koen De Groote wrote:
What I'm trying to do is upgrade a PG11 database to PG16, using logical
replication.
Have you looked at pg_upgrade?:
https://www.postgresql.org/docs/current/pgupgrade.html
The PG11 has an active and a standby, there are a handful of databases.
On particular one has a few tables just over 100GB, then a few 100
tables near 1GB.
1 GB each?
What I'd do is start a publication with no tables and add them 1 at a
time, refreshing subscription each time.
This might take a long time, so my main questions relate to potential
network issues or various situations where the instance receiving the
logical replication, suddenly stop being able to receive.
Resyncing, and the effects of WAL buildup, are my main concern.
Accidentally sent a mail to only your email, sorry for that.
Regards,
Koen De Groote
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
