MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
Master Server / Primary Server Set Up 1. Configuration Changes in file “postgresql.conf“
|
1 2 3 4 5 6 7 8 |
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 was introduced in PostgreSQL 10 and it is different from streaming replication in many ways as described
I will tell how to install PostgreSQL Replication by using archive_command parameter on centos in this article. But usually I