pg_upgrade: the tricky and dangerous parts | Postgres.FM 052 | LIVE episode

Описание: Links:
"Upgrades" – PostgresFM episode 037:    • Upgrades | Postgres.FM 037 | #PostgreSQL #...  
recovery_target_lsn: https://postgresqlco.nf/doc/en/param/...
recovery_target_action: https://postgresqlco.nf/doc/en/param/...
pg_easy_replicate https://github.com/shayonj/pg_easy_re...
HN discussion of this tool: https://news.ycombinator.com/item?id=...
Waiting for Postgres 16: Logical decoding on standbys: https://pganalyze.com/blog/5mins-post...
pg_upgrade and logical replication (discussion in pgsql-hackers): https://www.postgresql.org/message-id...
allow to upgrade publisher node (proposal to natively support running pg_upgrade on publisher, WIP): https://commitfest.postgresql.org/43/...
❓🤔 pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? (discussion in pgsql-hackers): https://www.postgresql.org/message-id...