Use logical replication for tables in RDS for PostgreSQL

Replication allows a client to receive a continuous stream of updates from a PostgreSQL database, providing a near-realtime view of all changes as they occur

It's about 10 tables in the schema, so that means 11 replication slots per subscriber cluster So in production could be up to 99 slots, let's

postgresql create replication slot Create logical replication slots · Initiate logical decoding · Subscribe to changes on a standby · Persist logical replication slots even after a

postgres create logical replication slot The beauty of Postgres logical replication is that not only other Postgres instances can serve as the consumer of a replication stream,