pg replication slots - PostgreSQL 12 Streaming Replication in Ubuntu 18.04 · GitHub tt888 slot

PostgreSQL 12 Streaming Replication in Ubuntu 18.04 - PostgreSQL-12-Streaming-Replication-in-Ubuntu-18.04.md

I discuss the pros and cons of various RDS PostgreSQL replication options, including intra-Region, cross-Region, and logical replication.

This document provides an overview of setting up out of the box replication in PostgreSQL 9.4 without third party tools. It discusses write-ahead logs (WAL), replication slots, pg_basebackup, pg_receivexlog and monitoring replication. The presenter then demonstrates setting up replication on VMs with pg_basebackup to initialize a standby, configuration of primary and standby servers, and monitoring replication status. - Download as a PDF or view online for free

If max_slot_wal_keep_size is -1 (the default), replication slots may retain an unlimited amount of WAL files. Otherwise, if restart_lsn of a replication slot ...