Tag - PostgreSQL

Seamless Application Failover using libpq Features in PostgreSQL

libpq features in postgresql

When you build replication in PostgreSQL using Streaming replication, you cannot perform writes to a standby node; only reads. This way, you could offload reads or reporting queries to standby servers and send writes to master. Additionally, starting from PostgreSQL 10,
libpq  and
psql clients could probe the connection for a master and allow […]

Read more

How to Set Up Streaming Replication in PostgreSQL 12

Streaming Replication in PostgreSQL

PostgreSQL 12 can be considered revolutionary considering the performance boost we observe with partitioning enhancements, planner improvements, several SQL features, Indexing improvements, etc. You may see some of such features discussed in future blog posts. But, let me start this blog with something interesting. You might have already seen some news that there is […]

Read more

Percona Monitoring and Management (PMM) 2.0.1 Is Now Available

Percona Monitoring and Management 2.0.1

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring your database performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL®, MariaDB®, MongoDB®, and PostgreSQL® servers to ensure that your data works as efficiently as possible.

In this release, […]

Read more

Manage Your Complex Database Environments with Percona Monitoring and Management (PMM)2 GA

Percona Monitoring and Management 2

We are pleased to announce the General Availability of PMM2, our latest software release!
Created specifically to support open source software users, Percona Monitoring and Management (PMM) is a leading, free, open-source platform that allows you to actively manage and monitor the performance of your MySQL, MongoDB, and PostgreSQL database environments.
A recent Percona survey revealed […]

Read more