PGConf.Russia 2023

Мультитранзакции и возможные проблемы с ними

In this presentation, we cover multi-transactions, explain when they appear and how they can be monitored and checked. We also tackle the possible issue with multi-transaction ID wraparound and the problem of file absence in pg_multixact/offsets when restoring from a backup.

Кластер Corosync-Pacemaker. Работа над ошибками

I will talk about the common mistakes when setting up a Corosync-Pacemaker failover cluster. Often these mistakes lead to fatal consequences, and, as a result, to the rejection of the chosen solution in favor of others. Would you like to get a recipe for the "right" cluster?

Logical replication internals

The following topics will be covered as part of the presentation:

• Architecture of logical replication
• Publisher introduction
• Subscriber introduction
• Data syncronization introduction
• Logical decoding
• Replication slot
• output plugin

Обзор некоторых интересных исторических уязвимостей Postgres

I'm not a real security expert. But this will help me to do ELI5 explanation of the funniest historical Postgres CVEs.