Jamsher Khan August 3, 2021 0 Comments

Setup Streaming Replication with repmgr and barman in PostgreSQL 0 (0)

Setup Streaming Replication with repmgr and barman in PostgreSQL repmgr is an open-source toolset and it is used to automate, enhance, and manage PostgreSQL streaming replication. Natively setting up and managing streaming replication involves many manual steps which include:1. Configuring replication parameters in both primary and each standby node.2. Backing up primary node data with […]

 1,669 Total Views,  6 Views Today

READ MORE
Jamsher Khan July 17, 2021 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 […]

 1,461 Total Views,  2 Views Today

READ MORE
Jamsher Khan July 16, 2021 2 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 […]

 1,178 Total Views,  7 Views Today

READ MORE
Jamsher Khan July 15, 2021 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 […]

 940 Total Views,  4 Views Today

READ MORE
Jamsher Khan July 13, 2021 2 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 […]

 1,958 Total Views,  5 Views Today

READ MORE
Jamsher Khan July 8, 2021 2 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 […]

 1,661 Total Views,  6 Views Today

READ MORE
Jamsher Khan July 7, 2021 2 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 […]

 1,509 Total Views,  6 Views Today

READ MORE
Jamsher Khan June 26, 2021 0 Comments

Physical PostgreSQL Backup using BARMAN 0 (0)

Physical PostgreSQL Backup using BARMAN In the previous blog, we have demonstrated Install & Configured barman tool in Backup Server Click here to read more. In this blog, we will use barman tool to take database backups.   List available servers: Use command barman list-server to get the list configured server in barman. Show configured parameters: Use […]

 1,033 Total Views,  5 Views Today

READ MORE
Jamsher Khan June 23, 2021 0 Comments

Install and Configure BARMAN for PostgreSQL 5 (1)

Install and Configure BARMAN for PostgreSQL BARMAN (Backup and Recovery Manager) is an open-source administration tool for backup and disaster recovery of PostgreSQL servers. It allows performing remote backups of multiple servers. Following are barman features.        1) Open Source Tool.      2) Remote backup and restore of multiple Servers.      3) […]

 3,511 Total Views,  12 Views Today

READ MORE