0 Comments

Backups from the Standby Server using pgBackRest in PostgreSQL 0 (0)

Backups from the Standby Server using pgBackRest in PostgreSQL   In the previous blog, we have configured Streaming Replication Cluster using pgBackRest Click here to read more. We will use the same PostgreSQL cluster to show How we can take a backup from Standby Cluster using pgBackRest.  Below are the high-level steps which we will […]

 348 Total Views,  1 Views Today

0 Comments

Traditional Barman Setup With WAL Streaming in PostgreSQL 0 (0)

Traditional Barman Setup With WAL Streaming in PostgreSQL In the previous blog, we saw How To Configure Traditional Barman Backup Setup via rsync/ssh  Click here to read more. And How To Configure Streaming Backup & WAL Streaming using BARMAN Click here to read more. In this blog, we will combine features offered by both Setup […]

 480 Total Views,  2 Views Today

0 Comments

Traditional Barman Setup With WAL archiving via archive_command in PostgreSQL 0 (0)

Traditional Barman Setup With WAL archiving via archive_command in PostgreSQL   In the previous blog, we saw How To Configure Traditional Barman Backup Setup via rsync/ssh  Click here to read more. In this blog, we will replace archive_command for WAL archiving via rsync with barman-wal-archive. From Barman 2.6, the recommended way to safely and reliably […]

 355 Total Views

0 Comments

Streaming Backup With Fallback WAL Archiving in PostgreSQL 5 (1)

Streaming Backup With Fallback WAL Archiving in PostgreSQL In previous blog we saw How To Configure Streaming Backup & WAL Streaming using BARMAN Click here to read more. In this blog we will configure WAL archiving via barman-wal-archive along with WAL Streaming  for more robust architecture in PostgreSQL. This alternate approach requires:1. An additional SSH […]

 336 Total Views,  2 Views Today

0 Comments

Configure Streaming Backup and WAL Streaming using BARMAN in PostgreSQL 0 (0)

Configure Streaming Backup & WAL Streaming using BARMAN in PostgreSQL In our previous blog, we saw steps to set up Traditional BARMAN Setup via rsync/SSH Click here to read more.  In this blog, we will see How to Configure Streaming Backup & WAL Streaming using BARMAN in PostgreSQL. Traditionally, Barman has always operated remotely via […]

 807 Total Views,  3 Views Today

0 Comments

Point in Time Recovery (PITR) using pgBackRest in PostgreSQL 0 (0)

Point in Time Recovery (PITR) using pgBackRest in PostgreSQL In the previous blog, we saw How to perform Full recovery using backup taken from pgBackRest Click here to read more.   In this blog, we will see How to perform PITR using backup taken from pgBackRest in PostgreSQL. For demonstration, we will be using our PostgreSQL Cluster created on […]

 368 Total Views

0 Comments

Restore Backup using pgBackRest in PostgreSQL 0 (0)

Restore Backup using pgBackRest in PostgreSQL In the previous blog, we saw How to Install and Configure pgBackRest for Backup Click here to read more.  In this blog, we will see How to perform a restore of a backup taken from pgBackRest. We will complete steps for the below two scenarios: 1. Restore in the same directory […]

 751 Total Views,  2 Views Today

0 Comments

Point in Time Recovery (PITR) using BARMAN in PostgreSQL 0 (0)

Point in Time Recovery (PITR) using BARMAN in PostgreSQL In the previous blog, we saw How to perform Full recovery using backup taken from BARMAN Click here to read more. In this blog, we will see How to perform PITR using backup taken from BARMAN in PostgreSQL.  For demonstration, we will be using our PostgreSQL […]

 606 Total Views,  2 Views Today

0 Comments

Restore Backup using BARMAN in PostgreSQL 0 (0)

Restore Backup using BARMAN in PostgreSQL In previous blog, we saw How to Install and Configure BARMAN for Backup Click here to read more.  In this blog, we will see How to perform a restore of a backup taken from BARMAN. We will see complete steps for the below two scenarios: 1. Restore in the same […]

 555 Total Views,  2 Views Today

0 Comments

Point in Time Recovery (PITR) using pg_basebackup in PostgreSQL 5 (1)

Point in Time Recovery (PITR) using pg_basebackup in PostgreSQL In previous blog we saw How to perform Full recovery using backup taken from pg_basebackup  Click here to read more. In this blog we will see How to perform PITR using backup taken from pg_basebackup in PostgreSQL.  For the purpose of demonstration we will be using our second […]

 378 Total Views,  4 Views Today