Need to know more about logical replication slots : rPostgreSQL

website replication slot If you want to use these features, then you'll need to create a replication slot on the primary server Enough with all the theory, let's have a replication slot already exists Examples Advancing a physical replication slot: postgres=# SELECT slot_name, slot_type, active, restart_lsn, confirmed_flush_lsn FROM pg_replication_slotsgx

replication slot A replication slot has an identifier that is unique across all databases in a PostgreSQL cluster Slots persist independently of the connection using them and  As an administrator, you may find it necessary to calculate how many database connections are needed before installing CDC Replication on either a source or  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