PGConf.Russia 2025

Last year, we introduced built-in fault tolerance support in Postgres Pro Enterprise through BiHA. Our solution allows you to deploy a fault-tolerant Postgres cluster where, in the event of a failure of the primary node, a new primary node (leader) is automatically selected.

However, this brings up the issue of redirecting traffic to the new leader. This can be solved using our Proxima extension or an external TCP proxy server. Both solutions needed to periodically query the BiHA cluster to determine the primary node.

As an alternative, the latest version of BiHA introduced the ability to register custom functions that will be triggered by events such as leader change, node addition/removal, and others. We call this mechanism user callbacks. In this presentation, we’ll explain how the callbacks are implemented and discuss their usage.

Poolers play a crucial role in PostgreSQL database operations. In this talk, we’ll discuss the challenges we faced when using and implementing existing poolers and the benefits we gained by developing our own pooler.

So much has been said about PostgreSQL as the result of its program code. But Postgres is not just code. It’s the people who create it, develop it, and... leave a piece of themselves through comments.

What stories can we uncover from the comments in PostgreSQL’s code? We’ll discover what the most popular word is, which comments have been in the code since the very first public commit, how the style of communication has evolved with the product, and how we can see the human side behind the lines of code and comments.

What does a modern application developer need to transition from familiar cloud-based solutions to SQL databases?

This talk is a practical report on how we transformed an SQL database into a NoSQL-like solution with a developer-friendly interface. We’ll discuss:

What application developers expect from a data framework

How to implement declarative DDL, access control, and automation for reading and writing data

Simplified DML operations, pagination, and other essential features for application development