0 Comments

Configure Logical Replication in PostgreSQL 0 (0)

Configure Logical Replication in PostgreSQL   In the recent three blogs, we discuss briefly on Replication available options in PostgreSql Click here to read more. And How To Configure File-Based Log Shipping in PostgreSQL Click here to read more. How To Configure Streaming Replication  in PostgreSQL Click here to read more. And In this blog, we will implement Logical Replication in PostgreSQL.  Logical replication is […]

 115 Total Views,  8 Views Today

0 Comments

Upgrade Database (July 2021 Patch Apply 19c) 19.3 to 19.12 in Oracle 4 (1)

Upgrade Database (July 2021 Patch Apply 19c) 19.3 to 19.12 in Oracle In this article, we are going to demonstrate the upgrade database from 19.3 to 19.12. To achieve it we will apply patch 32904851 of July 2021 (19.12.0.0.210720) on Oracle database version 19.3.0.0.0 which is multitenant architecture (CDB & PDB). Here it’s the current […]

 354 Total Views,  28 Views Today

0 Comments

Configure Streaming Replication (Record Based Log Shipping) in PostgreSql 0 (0)

Configure Streaming Replication (Record Based Log Shipping) in PostgreSQL In the recent two blogs, we discuss briefly on Replication available options in PostgreSql Click here to read more. And How To Configure File-Based Log Shipping in PostgreSQL Click here to read more. In this blog, we will implement Record Based Log Shipping also know as Streaming Replication in PostgreSQL.  […]

 91 Total Views,  2 Views Today

0 Comments

Configure File Based Log Shipping in PostgreSQL 0 (0)

Configure File Based Log Shipping in PostgreSQL In the previous blog, we discuss briefly on Replication available options in PostgreSql Click here to read more. In this blog, we will implement File Based Log Shipping in PostgreSQL. Below are setup details and the same will be used in this demonstration. Sr No Hostname IP Role […]

 97 Total Views,  1 Views Today

0 Comments

Oracle Critical Database Patch ID for July 2021 5 (1)

Oracle Critical Database Patch ID for July 2021 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch […]

 491 Total Views,  17 Views Today

0 Comments

Introduction to Replication in PostgreSQL 0 (0)

Introduction to Replication in PostgreSQL Introduction to Replication:- Replication refers to the process of copying modifications in data from the Primary database to the Standby database. Both these databases are usually located on different physical servers and help in distributing various types of database queries. Replication is implemented in PostgreSQL using a master-slave configuration. The […]

 118 Total Views,  5 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 […]

 90 Total Views

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

 85 Total Views,  1 Views Today

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

 78 Total Views,  1 Views Today

2 Comments

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

Configure Streaming Backup & WAL Streaming using BARMAN 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. Traditionally, Barman has always operated remotely via SSH, taking advantage of […]

 128 Total Views,  2 Views Today