Apr 17, 2019
 Percona Technical Webinar
  Avinash Vallarapu, Fernando Laudares Camargos, Jobin Augustine

Upgrading / Migrating your legacy PostgreSQL to newer PostgreSQL versions

This webinar starts with a list of solutions that are built-in to PostgreSQL to help us upgrade a legacy version of PostgreSQL with minimal downtime. The advantages of choosing such methods will also be discussed. You will notice a list of prerequisites for each solution, reducing the scope of possible mistakes. It's important to minimize downtime when upgrading from an older version of PostgreSQL server. Therefore, we will present 3 open source solutions that will help us either minimize or completely avoid downtime.

Additionally, we will be publishing a series of 5 blog posts that will help us understand the solutions available to perform a PostgreSQL upgrade. Our presentation will show the full process of upgrading a set of PostgreSQL servers to the latest available version. Furthermore, we'll show the pros and cons for each of the methods we employed.

Topics covered in this webinar include:

1. PostgreSQL upgrade using pg_dump/pg_restore (with downtime)
2. PostgreSQL upgrade using pg_dumpall (with downtime)
3. Continuous replication from a legacy PostgreSQL version to a newer version using Slony.
4. Replication between major PostgreSQL versions using Logical Replication
5. Fast upgrade of legacy PostgreSQL with minimum downtime.

We will walk you through the methods for 45 mins and demonstrate a few of the methods that you may find useful in your database environment. We will witness how simple and quick it is to perform the upgrade using these methods.



About the Authors

Avinash Vallarapu

Avinash Vallarapu joined Percona in the month of May 2018. Before joining Percona, Avi worked as a Database Architect at OpenSCG for 2 Years and as a DBA Lead at Dell for 10 Years in Database technologies such as PostgreSQL, Oracle, MySQL and MongoDB. He is a co-author of book - "Beginning PostgreSQL on Cloud" and has also given several talks and trainings on PostgreSQL. He has good experience in performing Architectural Health Checks and Migrations to PostgreSQL Environments.
 

Fernando Laudares Camargos

Fernando joined Percona in early 2013 after working 8 years for a Canadian company specialized in offering services based in open source technologies. Fernando's work experience includes the architecture, deployment and maintenance of IT infrastructures based on Linux, open source software and a layer of server virtualization. From the basic services such as DHCP & DNS to identity management systems, but also including backup routines, configuration management tools and thin-clients. He's now focusing on the universe of MySQL with a particular interest in understanding the intricacies of database systems. Fernando lives in the island of Florianópolis, Brazil, with his wife and kids. He enjoys spending time with them doing whatever activity they choose and resort to swimming, cycling and running in his search of balance to a life surrounded by computers. He also has a personal interest in education in general and loves to discuss the subject.
 

Jobin Augustine

I have been supporting various database systems for the last 17 years. I am an active member of the PostgreSQL community in India and participated as speaker and trainer in last pgConf India. I was working as an Architect in OpenSCG for the last couple of years which was taken over by Amazon recently. I was actively involved in the opensource project BigSQL-A PostgreSQL distribution to make PostgreSQL more developer friendly. I´m enthusiastic about joining this team and a great Open Source company.