2 Comments

Access Oracle database from PostgreSQL using Oracle Foreign Data Wrapper (ORACLE_FDW) 5 (1)

Access Oracle database from PostgreSQL using Oracle Foreign Data Wrapper (ORACLE_FDW) Nowadays many companies are using a mix of RDBMS systems, for example, some instances are running on Oracle and other instances are running on PostgreSQL, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow […]

 1,374 Total Views

0 Comments

Steps to Setup Database Link in PostgreSQL 4 (1)

Steps to Setup Database Link in PostgreSQL Database Link in PostgreSQL enables a database user to access a table present on a different PostgreSQL cluster. It provides a functionality in PostgreSQL similar to that of DB Link in Oracle, Linked Server in SQL Server and Federated Table in MySQL. In previous post we saw How to […]

 2,343 Total Views

0 Comments

Steps to Setup a Foreign Data Wrapper(postgres_fdw) in PostgreSQL 0 (0)

Steps to Setup a Foreign Data Wrapper(postgres_fdw) in PostgreSQL A foreign data wrapper (postgres_fdw) is an extension available in PostgreSQL that allows you to access a table or schema in one PostgreSQL database from another PostgreSQL DB. For this demonstration, we’ll use the databases local_db and remote_db. We will access a table employee in remote_db […]

 1,271 Total Views

0 Comments

Steps to create a Database Link from Oracle to PostgreSQL 0 (0)

Steps to create a Database Link from Oracle to PostgreSQL Nowadays many companies are using a mix of RDBMS system for example, some instances are running on Oracle and other instances are running on PostgreSQL, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow us […]

 2,063 Total Views

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

 2,262 Total Views

0 Comments

Configure PgBouncer for PostgreSQL 0 (0)

Configure PgBouncer for PostgreSQL PostgreSQL has a heavyweight connection handling architecture. For each incoming connection, the postmaster forks out a new process  called as backend process to handle it. While this design provides better stability and isolation, it does not make it particularly efficient at handling short-lived connections. A new Postgres client connection involves TCP […]

 1,595 Total Views

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,598 Total Views,  1 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

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,456 Total Views

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,917 Total Views