PGConf.Russia 2025

Every day, thousands of engineers work tirelessly to make data more accurate, reliable, and up-to-date. But sometimes, we need to do the exact opposite—corrupt it.

Whether it’s masking or replacing sensitive information, or even generating entirely new datasets while preserving key business properties, data obfuscation is a crucial task. It’s essential for testing systems, sharing data with third parties, and more. However, given the complexity of data schemas and business logic, this is far from trivial.

In this talk, we’ll explore the challenges of working with artificial data and discuss various approaches to solving them using PostgreSQL’s built-in features and external extensions.

There are many administrator consoles out there, ranging from the old-school DBeaver to the ubiquitous pgAdmin. However, we decided to create another one. Why?

In this talk, you’ll learn:

• How can a single installation manage tens of thousands of database instances.

• How many users can the console support.

• How can you inventory your infrastructure without losing your sanity.

• How do you integrate into an existing environment without starting from scratch.

• How to build a security model that earns the trust of leading banks and telecom operators.

• How can you get hands-on experience with all of this.

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

Diagnostic Methods: Analyzing the Issue of Long CREATE DATABASE Execution

This talk covers two cases of long CREATE DATABASE execution in PostgreSQL 11, which, in a Corosync/Pacemaker cluster configuration, caused node failover due to a monitoring timeout from the clustering software. The first case is related to a large shared buffers size, while the second involves the use of the WITH OWNER option during database creation and a large pg_shdepend system table (a feature of using the jBPM software).