Course Curriculum
| Introduction to Database upgrades | |||
| pg_upgrade tool | 00:24:00 | ||
| Why Upgrading Postgres Is Complex | 00:45:00 | ||
| Release History | 00:04:00 | ||
| Major enhancements in PostgreSQL 9.6 | 00:54:00 | ||
| Preparing for upgrade | 00:24:00 | ||
| Upgrade without Downtime | 00:14:00 | ||
| pg_dump utility (logical backup) | 00:04:00 | ||
| Slony-I | 00:14:00 | ||
| Postgresql 8.3 upgrade limitations | 00:14:00 | ||
| Bucardo | 00:30:00 | ||
| Disadvantages | 00:43:00 | ||
| Dblinks | 00:04:00 | ||
| Querying Remote servers with DbLink and Bulk Insert | 00:04:00 | ||
| Foreign Data Wrappers(postgres_fdw) | 00:53:00 | ||
| Creating a foreign table with postgres_fdw | 00:05:00 | ||
| Create a foreign table with CREATE FOREIGN TABLE | 00:09:00 | ||
| Pglogical | 00:50:00 | ||
| Architectural details | 00:07:00 | ||
| Compatibility Matrix | 00:50:00 | ||
| Postgresql 8.3 upgrade limitations | 00:14:00 | ||
| Upgrade options | 00:12:00 | ||
| Upgrade Syntax | 00:25:00 | ||
| Standby Setup | 00:04:00 | ||
| Post upgrade steps | 00:14:00 | ||
| Sample Run: Performance Consistency Checks | 00:33:00 | ||
| Sample Run: Performing Migration | 00:11:00 | ||
| Sample Run: Completion | 00:02:00 | ||
| Possible Data Format Changes | 00:07:00 | ||
| Speed Comparison | 00:08:00 | ||
| Backout Plan | 00:46:00 | ||
Apply for Course5 SEATS LEFT
- 1 Days
- 5 SEATS
- Course Badge
Course Badge
14 STUDENTS ENROLLED
