Application of replication slots in PostgreSQL

website start replication slot postgres This parameter can only be set at server start Setting it to a lower value than the number of currently existing replication slots will prevent the server from start replication slot postgres By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL

start replication slot postgres The concept of replication slots was introduced in PostgreSQL and was created to prevent a primary instance to delete WAL that a replica  When replication slots is enabled, you might end up running out of disk space due to PostgreSQL trying to retain WAL files requested by a replication slot   Create a replication slot, which will hold the state of the replication stream: SELECT * FROM pg_create_logical_replication_slot; If

Share

Share

Link

Turn off sharing Copy link

See all details