Presented by:

00e66352d49e89b50b086261e0d80120

Kevin Kempter

ProPAAS

Kevin is the founder of ProPAAS a PostgreSQL Managed Services Company, Kevin has worked in IT since 1990 and has been working with databases since 1995, specializing in PostgreSQL since 2004. Today Kevin manages the ProPAAS Team, leads platform conversions, and delivers ProPAAS public training.

No video of the event yet, sorry!

A presentation of Foreign Data Wrappers to include technical deployment details, usage, and use cases (including a vehicle for platform conversions)

Outline:

  • Overview

  • Creating the extension / installation

  • Creating a foreign server

  • User mapping

  • Import foreign schema

  • FDW Joins

  • FDW as a materialized view

  • FDW triggers

  • FDW and transactions

  • Detecting changes in a remote table

  • Platform conversion via Foreign Data Wrappers

  • Sampling of Extensions & available FDW's

    • Oracle
    • MySQL
    • www
    • S3
    • Redis
    • CouchDB
    • Docker
    • Facebook

Date:
Duration:
50 min
Room:
Conference:
PostgresConf US 2018
Language:
English
Track:
Operations and Administration
Difficulty:
Medium