by Sonia Valeja | Feb 7, 2024 | Insight for DBAs, PostgreSQL
Backup management is the backbone of any reliable database administration strategy, and while pgBackRest simplifies this process, its default configuration often combines backup and expiry together. At times, due to slow network bandwidth, huge database sizes, or any... by Sonia Valeja | Aug 16, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free databases. PostgreSQL developers and database administrators often deal with complex SQL queries, making code readability a critical... by Sonia Valeja | Jun 7, 2023 | Insight for DBAs, PostgreSQL
PostgreSQL provides a powerful mechanism for implementing event-driven actions using triggers. Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database... by Sonia Valeja | 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... by Sonia Valeja | Dec 23, 2022 | Insight for DBAs, Open Source, PostgreSQL
Patroni is one of the most used high availability (HA) solutions with the PostgreSQL database. It uses a Distributed Configuration Store (DCS) to keep the configuration in a centralized location available for all nodes making it an easy-to-use and reliable HA solution...