Tag: PostgreSQL Replication

5 Dec by Amzad Ali Tags: ,

PostgreSQL Streaming Replication

  Master Server / Primary Server Set Up 1. Configuration Changes in file “postgresql.conf“ [crayon-5c192e18e8a20639571987/]   2. Configuration Changes in file “pg_hba.conf” Make an entry for replication user with Slave server IP: [crayon-5c192e18e8a2a105613266/]   3. Restart the PostgreSQL service in Primary for changes to get impact: [crayon-5c192e18e8a2d008387718/]   Slave Server/ Secondary Server Set Up 1.Stop […]
27 Aug by Nikhil Shetty Tags:

Logical Replication

  Logical replication was introduced in PostgreSQL 10 and it is different from streaming replication in many ways as described below:  Logical replication works at the object level unlike streaming replication which works at the cluster level, so you can replicate individual tables as per requirements such as logging,analysis,backup, etc. Once you have decided which […]
11 Jun by dbtut Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

How To Install PostgreSQL Replication On Centos

First we go to https://yum.postgresql.org and into PostgreSQL where we will download the repo. Since we will use PostgreSQL 10 in our example, we will click on 10.   Then right click on “Centos 7 – x86_64” in the screen below and we click copy link location.   We connect to our Centos server via […]