Upgrading to PostgreSQL 16.x
PostgreSQL.org has officially unveiled PostgreSQL 16, the latest iteration of the world’s most advanced open-source database. This new version brings substantial enhancements in query performance, particularly for larger datasets, and introduces innovations in space utilization, enabling more efficient storage management. Alongside these critical improvements, PostgreSQL 16 delivers a host of advanced features designed to empower developers and administrators, including enhanced JSON support, improved parallel query execution, and robust security updates.
Course Contents:
- 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
Virtual live Training
Training Expired
