CYBERTEC Logo

PostgreSQL High Availability & Patroni Cluster Manager

LEVEL: Expert
Target group for this course are experienced PostgreSQL users with at least basic Linux knowledge (command line, editing of configuration files)
Book Now

Course Topics

AGENDA

Overview of PostgreSQL High Availability (HA)

  • binary replication
  • typical replication problems and solutions
  • built-in HA mechanisms
  • switchover and failover
  • logical replication

HA automation

  • basic concepts
  • standard HA problems
  • decisions with consensus
  • different approaches

Patroni

  • basic idea & introduction
  • installation
  • configuration & operation
  • common problems

Patronictl

  • extended functionalities
  • postgresql.conf + pg_hba.conf replacement

Routing of client requests

  • libpq/JDBC
  • vip manager
  • HAProxy

Updates and upgrades

  • PostgreSQL updates
  • Patroni updates

Course INFO

Level Expert

For Soon-to-be-Experts.

Language

English

Location

Online

Date

23. September 2024 -
25. September 2024
Duration: 3 Days

Time

Start
End
Time Zone:
Make a Booking Request
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram