Development

Upgrading to PostgreSQL 12.x

Descriptions

PostgreSQL.org 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.

Pre-Requisite:

Basic Structured Programming Knowledge or experience
Linux or Windows OS
PostgreSQL basics and/or SQL basics.

Program Outline

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

Certification Exam Number & Details:

Exam Number: PGU

Exam Requirements:

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.

Exam Details:

Number Of Questions:60 Questions

Time Allocated:90 Minutes

Minimum Pass Requirement: 70%

Certification Renewal is required every three years.

Target Audience:

share it :

Development

Upgrading to PostgreSQL 12.x

Descriptions

Target Audience:

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

Newsletter