Jamsher Khan August 25, 2021 0 Comments

Setup Logical Replication using pglogical in PostgreSQL 5 (1)

Setup Logical replication using pglogical in PostgreSQL In the recent two blogs, we discuss built-in options like Streaming replication Click here to read more and Logical replication Click here to read more. In this blog, we will use pglogical extension to setup logical streaming replication for PostgreSQL. The pglogical extension provides logical streaming replication for PostgreSQL, using […]

 1,896 Total Views,  1 Views Today

Spread the Knowledge!
               

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

 892 Total Views,  1 Views Today

Spread the Knowledge!
               

READ MORE
Jamsher Khan August 18, 2021 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,258 Total Views,  1 Views Today

Spread the Knowledge!
               

READ MORE
Jamsher Khan August 8, 2021 0 Comments

Configure automatic failover with repmgrd in PostgreSQL 0 (0)

Configure automatic failover with repmgrd in PostgreSQL In the recent two blogs, we discuss How to Setup Streaming Replication with repmgr and barman Click here to read more and How to perform manual Failover & Switchover of PostgreSQL Cluster using repmgr Click here to read more. In this blog, we will configure repmgr to perform Automatic failover when […]

 1,099 Total Views

Spread the Knowledge!
               

READ MORE
Jamsher Khan August 6, 2021 0 Comments

Perform Manual Failover & Switchover using repmgr in PostgreSQL 0 (0)

Perform Manual Failover & Switchover with repmgr in PostgreSQL In the recent blog, we discuss How to Setup Streaming Replication with repmgr and barman Click here to read more. In this blog, we will perform Manual Failover & Switchover using repmgr in PostgreSql. We will use the same setup we did in the last blog. Below […]

 1,523 Total Views

Spread the Knowledge!
               

READ MORE
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,347 Total Views,  2 Views Today

Spread the Knowledge!
               

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

 1,008 Total Views

Spread the Knowledge!
               

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

 1,085 Total Views

Spread the Knowledge!
               

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

 946 Total Views

Spread the Knowledge!
               

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

 1,189 Total Views,  1 Views Today

Spread the Knowledge!
               

READ MORE