PostgreSQL Upgrades
PostgreSQL Upgrades
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 )
- Date:
- 2024 February 28 - 14:00
- Duration:
- 3 h 30 min
- Room:
- Grand Victoria B
- Conference:
- PGConf India, 2024
- Language:
- Track:
- Training
- Difficulty:
- Medium
- Unraveling GEN AI and PG Vector in PostgreSQL
- Start Time:
- 2024 February 28 14:00
- Room:
- Grand Victoria A
- Distributed SQL on containers: YugabyteDB hands-on lab
- Start Time:
- 2024 February 28 14:00
- Room:
- Robusta
- PostgreSQL Extensions
- Start Time:
- 2024 February 28 14:00
- Room:
- Arabica