PGConf.Russia 2025

Many Russian companies are striving to establish themselves in the relational database market by developing their own commercial solutions, often based on forks of vanilla PostgreSQL. But beyond the database itself, customers also need a graphical management tool — Enterprise Manager. Since forking it is extremely challenging, vendors often have to build their own from scratch while considering competitive solutions.

This talk will explore Enterprise Managers from various Russian database vendors, comparing their key features — functionality, usability, and design — to identify which one stands out as the most effective.

As part of the import substitution process, we encountered the need to find a reliable alternative to Oracle. PostgreSQL was considered the primary candidate for replacement, but during the research, the "vanilla" version revealed a number of critical limitations that hindered a successful transition.

These issues included support for autonomous transactions, batch variables, and several other specifics. What is special about pg_settings? Why do we need autonomous transactions, and how do HOLD cursors relate to this? These and other topics will be discussed in our presentation, where we will also share our experience of implementing Postgres Pro Enterprise.

This talk will explore different approaches to storing files in PostgreSQL, including:

• Simple table-based storage

• Large objects with pg_largeobject

• pgpro_sfile – a large object (pgpro_bfile) storage solution