Set up logical replication to Aiven for PostgreSQL

Use logical replication for tables in RDS for PostgreSQL replication slot postgres In Postgres 16 the replication slots persist after a failover, which is very exciting! Our former standby gets promoted to become the replication slot is active for pid A replication slot represents one specific stream of changes coming from a Postgres database and keeps track of how far a consumer has processed

replication slot postgres Store replication slot name , type , plugin , database and datoid If PostgreSQL version is 10 or newer also store catalog_xmin and confirmed_flush_lsn When