Interview with Redgate

Any views or opinions represented or expressed in this interview belong solely to the interviewee and do not necessarily represent those of the PGConf.DE 2025 organization, PostgreSQL Europe, or the wider PostgreSQL community, unless explicitly stated.

In which areas do you expect PostgreSQL to grow most and how does your company contribute to and benefit from that growth?

Our enterprise customers are experiencing a change in their database architecture topologies. One database can no longer serve every need, instead, companies are searching for the best fit for a given project and anticipated ROI. In many cases, we see PostgreSQL as a go-to database for greenfield projects and application migrations alike. When database landscapes expand, companies need tools to deliver consistent value to users across multiple database platforms. That's where Redgate can help with its end-to-end database DevOps solutions.

With tools like Flyway, development teams can efficiently manage database migrations across the entire development pipeline. SQL Monitor provides a best-in-class database monitoring solution with alerting, historical server statistics, and query metrics over time.

Redgate Test Data Manager product simplifies the challenges that come with Test Data Management (TDM) and modern software development across multiple databases. Organizations are enabled to introduce reliable and compliant test data delivery to development processes, improving the quality of releases and reducing risk, while slotting seamlessly into existing workflows.

What is your PostgreSQL centered product and what makes it unique?

The tool that most people know, including many in the PostgreSQL community, is Flyway, an advanced schema migration application that can be used across more than 50 databases. Advanced features in Flyway Teams and Enterprise allow teams of developers to work with their PostgreSQL database as code. Flyway maintains a schema model of your database with each commit, generating consistent migration scripts as you develop, solving a myriad of common issues in your deployment pipeline. Redgate Data Treatment provides powerful tools to mask and subset production data into secure and manageable datasets that increase the confidence of developers and teams. And Redgate Monitor provides industry leading monitoring, alerting, and historical performance tracking in a single pane of glass, supporting PostgreSQL, SQL Server, Oracle, and MySQL. Each of these products work together to build consistent and reliable database development and deployment pipelines to increase velocity and delivery of value to end users.

Which PostgreSQL extension do you benefit from most, and why?

Two things come to mind regarding PostgreSQL extensions. First, managing extensions and extension versions is an important part of having consistent deployments with any PostgreSQL-backed application. Flyway Teams and Enterprise track extension versions and maintain this information in the schema model, ensuring that all schema comparison and script generation validate that right extension is being used across your development pipeline.

Second, Redgate Monitor relies on the venerable pg_stat_statements extension, among others, to help customers visualize and track the performance of application queries over time. By consistently sampling this data over time, Redgate Monitor helps clients quickly zero in on issues with their PostgreSQL clusters, saving valuable time in database management.

Most recently, Redgate has rearchitected the Redgate Monitor data repository to offer PostgreSQL with the TimescaleDB extension as an alternative to a SQL Server database repository. The results have significantly improved the speed, reliability, and storage capabilities of our flagship monitoring software.