PGConf.Russia 2025

In 2024, Postgres Professional introduced pgpro-otel-collector, a new tool for gathering PostgreSQL telemetry data using OpenTelemetry technologies and standards.

In this talk, I’ll explain why we chose OpenTelemetry, showcase the features of pgpro-otel-collector, and demonstrate how it helps streamline telemetry collection within a monitoring infrastructure.

This presentation examines the challenges of migrating an application system from Oracle to Postgres, based on a real-world project. It provides a detailed discussion on logical replication of data from Postgres to ensure the possibility of reverting back to Oracle while maintaining the functionality of legacy reporting and integration.

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.