postgres max_replication_slots - Best practices for Amazon RDS PostgreSQL replication | AWS Database ... online slot 888

postgres=# SELECT slot_name, slot_type, active FROM pg_replication_slots; slot_name | slot_type | active . slot1 | physical | f (1 row).

If replication slots will be used, ensure that max_replication_slots is set sufficiently high as well. ... postgres=# SELECT * FROM pg_create_physical_replication_slot('node slot_name | lsn .

Property max_replication_slots should be greater than zero for logical replication, because logical replication can’t work without replication slot.