Chapter 10. Data Migration from Other Databases to PostgreSQL and Upgrading the PostgreSQL Cluster

In this chapter, we will cover the following recipes:

  • Using the pg_dump to upgrade data
  • Using the pg_upgrade utility for version upgrade
  • Replicating data from other databases to PostgreSQL using Goldengate

Introduction

During the career of a database administrator, he/she will often be required to do major version upgrades of the PostgreSQL server. Over a period of time, new terminologies and features get added to PostgreSQL, and this results in a major version release. To implement the new features of the new version, the existing PostgreSQL setup needs to be upgraded to the new version. Database upgrades require proper planning, careful execution, and ...

Get PostgreSQL High Performance Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial