postgres

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...

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? ...