pg_upgrade: the tricky and dangerous parts
Postgres FM
00:00
The Problem With Initializing a Physical Replica
Instead of regular installation, we use physical replicants. We don't need the first one because physical already brought us everything. So now we have second problem. This problem is quite interesting. If you first initialize logical replication, and then shut down your logical replica, run to generate and start again, there are risks of data corruption. It could be a page based backup, it could be PGB crest or WALG fetching whole database from backups. Or anything else.
Transcript
Play full episode
