$1,195

Event Information

Share this event

Date and Time

Location

Location

Las Vegas

5550 Painted Mirage Road

Las Vegas, NV

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Introduction to Database upgrades

• Various Methods

• pg_upgrade tool

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

Pre-Requisite:

PostgreSQL Knowledge of 8.x or 9.x.

Target Audience:

Existing PostgreSQL DBA's using older versions.

Share with friends

Date and Time

Location

Las Vegas

5550 Painted Mirage Road

Las Vegas, NV

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved