Set up logical replication to Aiven for PostgreSQL

Preventing WAL Growth on Postgres DB Running on AWS RDS postgres replication slot postgres=# SELECT * FROM pg_replication_slot_advance; ERROR: replication slot physical_slot_1 cannot be advanced DETAIL: This postgres create logical replication slot A replication slot ensures that the WAL will not go away if the replica lags behind Without a replication slot, a primary will recycle its WAL as soon as it

postgresql create replication slot This issue occurs in PostgreSQL when a user attempts to create or manage replication slots without the necessary privileges