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 […]

 1,597 Total Views,  7 Views Today

0 Comments

Setup Streaming Replication with pgBackRest in PostgreSQL 0 (0)

Setup Streaming Replication with pgBackRest PostgreSQL In the recent two blogs, we discuss How to set up Streaming Replication Click here to read more and Configure pgbackrest on Database Server – Local Click here to read more. In this blog, we will demonstrate How to Setup Streaming Replication with pgBackRest in PostgreSQL. Below are the high-level steps we […]

 1,586 Total Views,  7 Views Today

4 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 […]

 1,431 Total Views,  10 Views Today

2 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 […]

 1,852 Total Views,  9 Views Today

2 Comments

Physical Backup using pgBackRest in PostgreSQL 0 (0)

Physical Backup using pgBackRest in PostgreSQL In the previous blog, we have demonstrated Configure pgbackrest on Backup Host – Remote in Backup Server Click here to read more. In this blog, we will use the pgbackrest tool to take different types of database backup. pgBackRest is an open-source backup tool for PostgreSQL which offers easy configuration and reliable […]

 979 Total Views,  2 Views Today

2 Comments

Configure pgbackrest on Backup Host – Remote in PostgreSQL 5 (1)

Configure pgbackrest on Backup Host – Remote in PostgreSQL In the previous blog, we demonstrated How to install pgbackrest on Database Server – Local in PostgreSQL Click here to read more. Such setups are not used in a production environment to perform the backup on the same server where the database is running. In this blog, […]

 1,716 Total Views,  9 Views Today

0 Comments

Configure pgbackrest on Database Server – Local in PostgreSQL 5 (2)

Configure pgbackrest on Database Server – Local in PostgreSQL pgBackRest is an open-source backup tool for PostgreSQL which offers easy configuration and reliable backups. pgBackRest is a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms optimized for database-specific requirements. Some of the key […]

 981 Total Views,  1 Views Today