Wed, 07 Feb 2024 14:57:07 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/decoupling-backup-and-expiry-operations-in-postgresql-with-pgbackrest/ https://www.percona.com/blog/decoupling-backup-and-expiry-operations-in-postgresql-with-pgbackrest/#respond Wed, 07 Feb 2024 14:57:07 +0000 https://www.percona.com/blog/?p=94165 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 other resource crunch, expiring backups (i.e., deleting the older backups) require more than taking backups for databases. […]]]> https://www.percona.com/blog/decoupling-backup-and-expiry-operations-in-postgresql-with-pgbackrest/feed/ 0 94165 https://www.percona.com/blog/streamline-the-sql-code-guide-to-pgformatter/ https://www.percona.com/blog/streamline-the-sql-code-guide-to-pgformatter/#respond Wed, 16 Aug 2023 12:10:11 +0000 https://www.percona.com/blog/?p=89918 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 factor for productivity. A powerful tool designed to beautify and standardize SQL code is pgFormatter. This guide to […]]]> https://www.percona.com/blog/streamline-the-sql-code-guide-to-pgformatter/feed/ 0 89918 https://www.percona.com/blog/power-of-postgresql-event-based-triggers/ https://www.percona.com/blog/power-of-postgresql-event-based-triggers/#respond Wed, 07 Jun 2023 13:35:43 +0000 https://www.percona.com/blog/?p=88323 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 schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other […]]]> https://www.percona.com/blog/power-of-postgresql-event-based-triggers/feed/ 0 88323 https://www.percona.com/blog/what-if-the-backup-server-is-down-and-a-backup-is-needed-multi-repo-functionality-of-pgbackrest/ https://www.percona.com/blog/what-if-the-backup-server-is-down-and-a-backup-is-needed-multi-repo-functionality-of-pgbackrest/#respond Tue, 28 Mar 2023 12:01:40 +0000 https://www.percona.com/blog/?p=86413 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. In […]]]> https://www.percona.com/blog/what-if-the-backup-server-is-down-and-a-backup-is-needed-multi-repo-functionality-of-pgbackrest/feed/ 0 86413 https://www.percona.com/blog/rebuild-patroni-replica-using-pgbackrest/ https://www.percona.com/blog/rebuild-patroni-replica-using-pgbackrest/#comments Fri, 23 Dec 2022 13:19:21 +0000 https://www.percona.com/blog/?p=84287 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 available in the market today.On the other hand, pgBackRest is a backup solution […]]]> https://www.percona.com/blog/rebuild-patroni-replica-using-pgbackrest/feed/ 2 84287