EDB

How to replicate tables in postgres using EDB replication server

EDB replication server tool can be used to replicate tables between databases. Below topologies are supported by this tool. Between postgres to postgres Between oracle to postgres and vice versa Betwe...

edb efm start failed with authentication failed error on standby

PROBLEM: We have rebooted both the primary and standby postgres nodes. After the reboot , the enterprise failover manager(EFM) , was not getting started on the standby node. PRIMARY NODE – 10.20...

Trigger file validation failed. Could not start agent as standby

PROBLEM: I have received below error , while starting efm agent on standby server. [root@dbhost41 edbdata]# systemctl start edb-efm-3.9 Job for edb-efm-3.9.service failed because the control process e...

How to change postgres data directory

Below article explains how to change postgres data directory to a new location existing data_directory – > /var/lib/edb/as11/data New data_directory -> /oradata/pgdata postgres os user &#8...

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 11

In this article, we will explain how to configure streaming replication in postgres (11)from existing primary database to a new standby database( slave). If your postgres version is 12 or higher , the...