POSTGRESQL Archives - Page 2 of 6

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

October 11, 2021

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…

📌

2💬 read more

Steps to Setup Database Link in PostgreSQL 4 (1)

October 5, 2021

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…

📌

1💬 read more

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

October 3, 2021

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…

📌

0💬 read more

Steps to create a Database Link from Oracle to PostgreSQL 5 (1)

October 1, 2021

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…

📌

0💬 read more

Setup Logical Replication using pglogical in PostgreSQL 5 (2)

August 25, 2021

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…

📌

0💬 read more

Configure PgBouncer for PostgreSQL 5 (1)

August 22, 2021

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…

📌

0💬 read more

Backups from the Standby Server using pgBackRest in PostgreSQL 0 (0)

August 18, 2021

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…

📌

0💬 read more

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…

📌

0💬 read more

Configure automatic failover with repmgrd in PostgreSQL 0 (0)

August 8, 2021

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…

📌

0💬 read more

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

August 6, 2021

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…

📌

0💬 read more