Upgrading a PostgreSQL database from a legacy to newer version with no downtime.
Presented by:
Avinash Vallarapu
Avinash Vallarapu (Avi) is the CEO and Co-founder of MigOps, Inc. Before joining MigOps, Avi worked as a Global Services Lead and Product Owner for PostgreSQL services at Percona, Database Architect at OpenSCG and Dell. Avi has a great expertise on Migrations to PostgreSQL. He has a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB for the last 2 decades. He is an avid Python and Golang developer. He has co-authored multiple books on PostgreSQL : Beginning PostgreSQL on Cloud and PostgreSQL 13 Cookbook.
He spoke at various PostgreSQL Conferences in the past including -
- PGCONF India - 2017/2019
- PGCON Ottawa 2018
- Percona Live Frankfurt 2018
- Postgres Conference New York 2019
- Percona Live Texas 2019
- Postgres Open Florida 2019
- Postgres Conference Silicon Valley 2019
- Percona Live Amsterdam 2019
- PGCONF India 2020, New York, Percona Live and some more conferences.
His areas of expertise are PostgreSQL Migrations, Training and Consulting.
No video of the event yet, sorry!
It is very important to know a fact that PostgreSQL community does not support bug fixes and security fixes for older PostgreSQL versions. Currently, community only supports PostgreSQL versions starting from 9.4. So, if your database server is on 9.3 or older, you would see no bug fixes or security patches. Several benchmarks proves that the performance of a PostgreSQL database increases with each version upgrade. Maintenance activities like autovacuum, Optimizer enhancements, new features like parallel query, declarative partitioning, etc. are implemented in the latest versions. Each new version includes a list of several features to improve the experience of working with PostgreSQL. So, it is recommended to have PostgreSQL upgraded to the latest release always. This talk is focussed towards demonstration of the 3 methods using which a PostgreSQL server can be upgraded from any version >= 8.3 to a latest release, with a seamless downtime.
Following topics will be discussed during this talk -
- 1. pg_upgrade and multiple replication methods such as pglogical and Slony for replication to a newer version.
- 2. What are the prerequisites you should take before proceeding with an upgrade.
- 3. HA Solutions and Backup strategy you may use for newer releases.
- 4. How future upgrades are made easy using Logical Replication and Logical Decoding.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference 2020
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Easy