Preventing WAL Growth on Postgres DB Running on AWS RDS

A replication slot is a PostgreSQL feature which ensures that a stream of changes stored in a WAL log file is replicated to the destination in the correct order

Preventing WAL Growth on Postgres DB Running on AWS RDS Logical replication of a table typically starts with taking a snapshot of the data on the publisher database and copying that to the subscriber Once that is

A replication slot is a PostgreSQL feature which ensures that a stream of changes stored in a WAL log file is replicated to the destination in the correct order

postgresql create replication slot However, until , PostgreSQL primarily supported only a physical replication stream A physical stream is only really useful for a second copy

There are two types of replication slots: logical and physical Logical slots have the property to be able to connect to a particular database,

postgresql drop replication slot Physical replication slots are an important new feature of PostgreSQL The idea is that a client can create a replication slot to make sure that the server

Publication slots configuration involves using the Create Replication Slot command in PostgreSQL to establish a slot dedicated to publishing data This