PostgreSQL Replication Archives - Database Tutorials

PostgreSQL Streaming Replication

Posted on December 5, 2018December 5, 2018 by Amzad Ali

Master Server / Primary Server Set Up 1. Configuration Changes in file “postgresql.conf“

listen_address=*
port=5432
wal_level=hot_standby
max_wal_senders=3
wal_keep_segments=32
hot_standby=on
archive_mode=on
archive_command='cp %p /usr/local/archive/%f'

listen_address=*

port=5432

wal_level=hot_standby

max_wal_senders=3

wal_keep_segments=32

hot_standby=on

archive_mode=on

archive_command='cp %p /usr/local/archive/%f'

2. Configuration Changes in

Logical Replication

Posted on August 27, 2018November 18, 2018 by Nikhil Shetty

Logical replication was introduced in PostgreSQL 10 and it is different from streaming replication in many ways as described

How To Install PostgreSQL Replication On Centos

Posted on June 11, 2018November 8, 2018 by dbtut

First we go to https://yum.postgresql.org and into PostgreSQL where we will download the repo. Since we will use PostgreSQL 10

Tag: PostgreSQL Replication

PostgreSQL Streaming Replication

Logical Replication

How To Install PostgreSQL Replication On Centos

Archives

Categories