Creating tablespace in a standalone postgres server is a very straight forward. But what if we need to create a tablespace in postgres with streaming replication enabled. Will the tablespace be crea...
replication
EDB failover manager (EFM) for managing streaming replication
EDB failover manager, popularly known as EFM is a component of EDB postgres platform, is used for handling switchover and failover (including auto failover) in postg...
How to setup streaming replication in postgres
In this article, we will explain how to configure streaming replication in postgres from existing primary database to a new standby database( slave). ENVIRONMENT DETAILS: PRIMARY SERVER= 10.20.30.40 S...
How to change port number in postgres
This article explains how to change the port number in postgres. We will change the port from 5444 to 5432 . 1. Check the existing port details postgres=# select * from pg_settings where name='port'; ...
Schema replication using oracle goldengate
In this tutorial, we will explain how to do schema replication in goldengate. Schema replication means, replicating all the tables of a schema. 1. add supplemental for all tables of a schema [ ...
Enable DDL replication in goldengate
In this below tutorial, we will enable DDL replication for a table, which is already part of goldengate replication and currently only DML transactions are getting replicated. TABLE_NAME = APPLIAN...