Presented by:

6a961946320454083402aab4cde4bba9

Christophe Pettus

from PostgreSQL Experts, Inc.

PostgreSQL has added in-core logical replication, and now the field of replication options in PostgreSQL has gotten wide: Streaming replication, warm standby, logical replication… We'll discuss what the options are, their limitations and pitfalls, and what the best use-case for each one is. We'll show what it takes to set each one up, monitor it, and get it working again on failures.

We'll cover:

  • The history of replication in PostgreSQL.
  • WAL shipping
  • Streaming replication
  • Trigger-based replication
  • Logical decoding
  • And some exotic animals.

Date:
Duration:
45 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2019
Language:
Track:
Postgres Track
Difficulty:
Medium

Happening at the same time:

  1. Your Herd of Elephants: PostgreSQL Replication
  2. Start Time:
    2019 April 28 12:30

    Room:
    HC-103 Postgres

  3. Live Coding Minesweeper in Clojurescript
  4. Start Time:
    2019 April 28 12:30

    Room:
    CC-115

  5. Deep Dive into firecracker-containerd
  6. Start Time:
    2019 April 28 12:30

    Room:
    CC-200

  7. Zero Knowledge Architecture, is it possible?
  8. Start Time:
    2019 April 28 12:30

    Room:
    CC-114

  9. When NoSQL isn't enough, but SQL is too much
  10. Start Time:
    2019 April 28 12:30

    Room:
    CC-208

  11. Ghostbusting
  12. Start Time:
    2019 April 28 12:30

    Room:
    G-103

  13. From Analog to Digital and Back
  14. Start Time:
    2019 April 28 12:30

    Room:
    CC-236

  15. Creating a Stronger Community by Poisoning Your Own Well
  16. Start Time:
    2019 April 28 12:30

    Room:
    HC-104 Jupiter

  17. Common licensing issues for free software projects
  18. Start Time:
    2019 April 28 12:30

    Room:
    HC-108

  19. Hugo: Making Building Websites Fun Again
  20. Start Time:
    2019 April 28 12:30

    Room:
    CC-201 Tutorials

  21. Snapcraft Workshop
  22. Start Time:
    2019 April 28 12:30

    Room:
    CC-202 Tutorials

  23. FreeBSD is Everywhere
  24. Start Time:
    2019 April 28 12:30

    Room:
    CC-235