Aug 02, 2025 |
Insight for DBAs, PostgreSQL
This post was originally written in 2023 and was updated in 2025. Encryption protects sensitive information by converting it into an unreadable format unless the correct passphrase or decryption key is supplied. In this post, we’ll look at how to encrypt the pgBackRest repository. pgBackRest is the backup solution widely used for PostgreSQL database backups, […]
Jul 28, 2025 |
Insight for DBAs, PostgreSQL, Security
This post was originally published in 2023 and was updated in 2025. Security is always a moving target, and PostgreSQL 15 makes important changes that close off a long-standing risk: default privileges on the public schema. For years, any new user could create objects in the public schema unless you explicitly revoked their rights. That […]
Jul 10, 2024 |
Insight for DBAs, PostgreSQL
The PostgreSQL Global Development team released the second beta version of PostgreSQL 17 on June 27th, 2024, and it is now available for testing. In this beta version, we can explore the new features that will be released in the official final release of PostgreSQL 17. In this blog, we will discuss some of the […]
Mar 22, 2024 |
Insight for DBAs, PostgreSQL
PostgreSQL configuration file parameters are very important when managing a PostgreSQL database, and this blog post will discuss the importance of backing those files up. The following are the primary configuration files of the PostgreSQL database: postgresql.conf: One of the most important configuration files for the PostgreSQL database is postgresql.conf file. This file contains a […]
Oct 09, 2023 |
Monitoring, Percona Software, PostgreSQL
Since Postgres table bloat degrades database performance, we can improve its performance by removing the table bloat. We can use the pgstattuple extension to identify the bloated tables. This extension provides several functions for obtaining tuple-level statistics. Because the pgstattuple functions produce extensive page-level information, access to them is, by default, limited. Only the pg_stat_scan_tables […]
Mar 28, 2023 |
Insight for DBAs, PostgreSQL
Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. […]