Upgrading to PostgreSQL 12.x

Descriptions released the new version of PostgreSQL 14 on feb 9, 2023, the world’s most advanced open-source database. PostgreSQL 14.X is now available with many impressive, beneficial, and critical improvements to query performance (particularly over larger data sets and overall space utilization) among other important features.
In this one-day hands-on training program, we’ll take a look at some of these new features and show you how to get and install this new PostgreSQL 12 version and as well as explore best practices and considerations to take into account when upgrading.


  • Basic Structured Programming Knowledge or experience
  • Linux or Windows OS
  • PostgreSQL basics and/or SQL basics.
  • Why Upgrading Postgres Is Complex
  • Release History
  • Major enhancements in PostgreSQL 13.X
  • Preparing for upgrade
  • Upgrade without Downtime
  • pg_dump utility (logical backup)
  • Slony-I
  • Limitations
  • Bucardo
  • Disadvantages
  • Dblinks
  • Querying Remote servers with DbLink and Bulk Insert
  • Foreign Data Wrappers(postgres_fdw)
  • Creating a foreign table with postgres_fdw
  • Create a foreign table with CREATE FOREIGN TABLE
  • Pglogical
  • Architectural details
  • Why Pg_Upgrade & Usage
  • Compatibility Matrix
  • Postgresql 8.3 upgrade limitations
  • Upgrade options
  • Upgrade Syntax
  • Standby Setup
  • Post upgrade steps
  • Sample Run: Performance Consistency Checks
  • Sample Run: Performing Migration
  • Sample Run: Completion
  • Possible Data Format Changes
  • Speed Comparison
  • Backout Plan
  • All candidates interested in becoming Certified PostgreSQL Developer are encouraged to attend hands-on instructor-led training at CertFirst or through one of its affiliated partners.

Number Of Questions:60 Questions

Time Allocated:90 Minutes

Minimum Pass Requirement: 70%

Certification Renewal is required every three years.

Target Audience:
share it :

Start your learning journey today! Enroll now in our course.