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...
postgres
How to open postgres standby database for read write(snapshot standby)
There is no technical term called snapshot standby in postgres. If you have knowledge of oracle database, then this snapshot standby method is there in dataguard. I.e you can open the standby databa...
How to do switchover in postgres
In this article we will explain how to do switchover manually . Switchover means, change of role between master and slave. postgres doesn’t provide any inbuilt command to do switchover . We will...
How to do failover in postgres
When you master server is crashed or inaccessible, then we can do failover and promote slave server as master. ENVIRONMENT DETAILS: PRIMARY SERVER(MASTER)= 10.20.30.40 STANDBY SERVER(SLAVE) =10.20.30....
How to configure streaming replication in postgres 14
In this article, we will explain how to configure streaming replication in postgres(14) from existing primary database to a new standby database( slave). The below steps will be same for POSTGRES 12/1...
How to install postgres in linux using rpm
In this we will explain how to install postgres 14.( Though installation steps are same for all versions). 1. Download the postgres server rpms. https://yum.postgresql.org/rpmchart/ 2.Install the rpms...
Generate performance report in postgres using pg_profile
If you have worked on oracle, then you must of aware of AWR report, which is used to generate workload performance report of the database for a specific duration. But in postgres there is no inbuilt f...
How to access oracle database from postgres
This article explain From postgres, how can we fetch oracle db data. For this we need to use foreign data wrapper and foreign table concepts. DEMO: 1.Create oracle client on postgres server: ...
How to create database link in postgres
This article explain how can we access data from a remote postgres database using db_link. In postgres we call achieve this using foreign data wrappers. 1. Create extension dblink if not present. post...
Real DBA Interview questions -4
Below are the questions asked to a candidate in a production based company. In ansible, what type of activites you did? What is a role in ansible? How you can print the output in ansible task? ...