Use logical replication for tables in RDS for PostgreSQL

Use logical replication for tables in RDS for PostgreSQL replication slot PostgreSQL Replication Slots Replication slots provide an automated way to ensure that the master does not remove WAL segments until they have replication slot postgres A replication slot is created on the primary database server for each standby server The slot keeps track of the last confirmed receive location of WAL data on

replication slot postgres Filling the disk causes the database instance to stop serving clients and thus a loss of service Assess the replication slots status via psql : SELECT

replication slot Logical replication slots In PostgreSQL® you can set up a logical replication slot for any downstream subscribers of the server Having a Examples Advancing a physical replication slot: postgres=# SELECT slot_name, slot_type, active, restart_lsn, confirmed_flush_lsn FROM pg_replication_slotsgx