Replication slot in PostgreSQL

website replication slot Examples Advancing a physical replication slot: postgres=# SELECT slot_name, slot_type, active, restart_lsn, confirmed_flush_lsn FROM pg_replication_slotsgx replication slot They work by storing the LSN of the WAL record most recently received by each subscriber When a replication slot is active, PostgreSQL will

replication slot The postgresql_replication_slot resource creates and manages a replication slot on a PostgreSQL server Usage resource postgresql_replication_slot my_slot  Logical replication slots In PostgreSQL® you can set up a logical replication slot for any downstream subscribers of the server Having a  The slot to be dropped must be inactive before it can be removed It is not possible to forcibly drop an active replication slot Change history PostgreSQL

Share

Share

Link

Turn off sharing Copy link

See all details