No video of the event yet, sorry!

Postgres Minor version and Major version upgrade strategies

• Why need to upgrade?
• Upgrade types - Minor and major version upgrades
• About Minor version upgrade
• About Major version upgrade
• Different ways of major version upgrades
• Postgres upgrade using pg_dumpall
• Postgres upgrade using pg_dump
• Postgres upgrade using pg_upgrade
• upgrade on RDS
• Postgres upgrade using logical replication
• Upgrade using PITR with LSN, pg_upgrade and logical replication to minimize downtime - https://www.percona.com/blog/the-magic-of-pitr-pg_upgrade-and-logical-replication-when-used-together-for-postgresql-version-upgrades/
• On RDS- Quickly setup logical replication for upgrade using snapshot upgrade to avoid data copy - https://www.percona.com/blog/postgresql-logical-replication-using-an-rds-snapshot/
• Performing a Major PostgreSQL Version Upgrade in a Cluster Managed by Patroni (if time permits )