Using the pt-pg-summary Percona Toolkit for PostgreSQL
The Percona Toolkit is a powerful, free, and open-source product developed by Percona. It is a collection of command-line tools that allow you to perform different MySQL, MongoDB, PostgreSQL, and system tasks that, in general,...
How to Deploy Percona Distribution for PostgreSQL for High Availability
High Availability is a requirement for many systems, no matter what technology you are using. This is especially important for databases, as they store data that applications rely upon. Depending on the requirements, there are...
How to Backup Your Amazon RDS for PostgreSQL Data and Restore on Your Own Server
Amazon Relational Database Service (Amazon RDS) is another service by Amazon, which allows you to deploy a scalable relational database in minutes in the cloud without the need to worry about infrastructure setup during the...
Monitoring Percona Distribution for PostgreSQL – Key Metrics
Monitoring is the base to know if your systems are working properly, and it allows you to fix or prevent any issue before affecting your business. Even in a robust technology like PostgreSQL, monitoring is...
Top Open Source Tools for PostgreSQL Migrations
Database migration is the process of migrating data from one or more source databases to one or more target databases by using a service or tool. There are different types of migrations. You can migrate...
An Overview of PostgreSQL 13 libpq sslpassword Connection Parameters
PostgreSQL since long has supported SSL connections and also certificate-based authentication mechanisms. Although nothing in this regard seems to be new for the PostgreSQL world. However, a small nagging issue for client connection (client-certificates based...
Using Barman for PostgreSQL Disaster Recovery
There must be many powerful tools available as a backup and restore option for PostgreSQL in general; Barman, PgBackRest, BART are to name a few in this context. What caught our attention was that Barman...
An Overview of PostgreSQL Query Caching & Load Balancing
The topic of caching appeared in PostgreSQL as far back as 22 years ago, and at that time the focus was on database reliability. Fast forward to 2020, the disk platters are hidden even deeper...
How to Upgrade PostgreSQL 11 to PostgreSQL 12 with Zero Downtime
The most intuitive database upgrade way that you can think of is to generate a replica in a new version and perform a failover of the application into it, and actually it works perfectly in...
Comparing load balancers for PostgreSQL
Load balancing increases system performance, especially from the application standpoint, allowing several computers to serve the same data. It works such that the load is being distributed among client queries to replica nodes aside from...
Scaling PostgreSQL Using Connection Poolers & Load Balancers
Scalability is the property of a system to handle a growing amount of demands by adding resources. The reasons for this amount of demands could be temporary, for example, if you are launching a discount...
Understanding the HAProxy Statistics for MySQL & PostgreSQL
Having a Load Balancer is always a good option to improve your database environment. It can help you on redirect applications to available database nodes, distribute the traffic across multiple servers to improve performance, or...