by Shivam Dhapatkar | 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... by Shivam Dhapatkar | Nov 30, 2023 | Insight for DBAs, PostgreSQL
Encryption is the process of turning data into an unrecognizable format unless the necessary password (also known as passphrase) or decryption key is provided. This blog describes how to encrypt the pgBackRest repository. pgBackRest is the backup tool used to perform... by Shivam Dhapatkar | Oct 9, 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.... by Shivam Dhapatkar | Jun 28, 2023 | Insight for DBAs, PostgreSQL, Security
In the Postgres database, the application data can be organized in various ways using Postgres schemas. In the Postgres database cluster, whenever we create a new database, It gets created with the default schema called public schema. This blog post will discuss the... by Shivam Dhapatkar | 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...