New Distribution of PostgreSQL Provides Expanded Support for Open Source Databases
More databases leads to a greater need for holistic visibility regardless of the technology and location.
Join the DZone community and get the full member experience.Join For Free
I had the opportunity to speak with Peter Zaitsev, CEO and Founder, Percona following his presentation on Distributed MySQL Architectures, Past, Present and Future at the Distributed SQL Summit in San Jose.
Earlier in the week, Percona announced the new distribution of PostgreSQL to provide expanded support for open source databases. According to Peter, as Percona started providing support to need single source to run PostgreSQL, they realized the need for monitoring from one source with the most appropriate versions and compatibility.
You might also like: 2019 Open Source Database Report
Percona Distribution for PostgreSQL provides organizations with a fully supported distribution of the database alongside management tools to make running applications based on PostgreSQL easier and deliver higher performance.
It is based on v11.5 of PostgreSQL and includes multiple open source tools for managing database instances and ensuring data is secure, available, and backed up for recovery. These include:
- pg_repack, a popular third-party extension to rebuild PostgreSQL database objects without requiring a table lock.
- pgaudit, a third-party extension that provides in-depth session and/or object audit logging through the standard logging facility in PostgreSQL. This enables PostgreSQL users to provide detailed audit logs for compliance and certification purposes.
- pgBackRest, a backup tool that replaces the built-in PostgreSQL backup offering. pgBackRest can seamlessly scale up to handle the largest database workloads. It uses streaming compression to help companies minimize storage requirements and delta restores to significantly lower the amount of time to complete a restore.
- Patroni, a high-availability solution for PostgreSQL implementations that is customizable, has a strong community and is widely used in production deployments.
- Additional extensions supported by the PostgreSQL Global Development Group
With the prominence of multi-database environments, the addition of PostgreSQL provides customers with enterprise support, services and consulting for all their open-source database instances across multiple distributions and across both on-premises and cloud deployments, expanding the range of companies that Percona can help to reach their goals. Additionally, Percona Monitoring and Management will also now support PostgreSQL.
“Companies are creating more data than ever, and they have to store and manage this data effectively,” said Peter. “Open source databases are becoming the platforms of choice for many organizations, and Percona provides the consultancy and support services that these companies rely on to be successful. Adding a distribution of PostgreSQL alongside our current options for MySQL and MongoDB helps our customers leverage the best of open source for their applications as well as get reliable and efficient support.”
Also, Peter asked me to remind European readers about Percona Live Open Source Database Conference Europe in Amsterdam, taking place from September 30 to October 2.
Opinions expressed by DZone contributors are their own.