Upgrading to PostgreSQL 12.x
On Demand $499.00
Virtual Live $795.00
Course Description
PostgreSQL.org released the new version of PostgreSQL 12 on October 3, 2019, the world’s most advanced open source database. PostgreSQL 12.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.
Prerequisite
- Basic SQL & Linux OS
Course Features
- Lectures 30
- Quizzes 0
- Duration 40 hours
- Skill level All levels
- Language English
- Students 587
- Certificate No
- Assessments Yes
-
Database upgrades
- Why Upgrading Postgres Is Complex
- Release History
- Major enhancements in PostgreSQL 9.6
- 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
