Working with PostgreSQL Replication Slots

website replication slot replication as opposed to physical replication -C: The option allows you to create a replication slot before the backup gets underway replication slot Recovering a read replica using its replication slot is faster than recovering from Amazon S3 archive So, we recommend that you monitor the replication slots

replication slot Replication slots are marked as 'inactive' when the replication client connected to the slot disconnects Inactive replication slots cause WAL files to be  If you want to know how Replicate creates slot and how to use it, you may set SOURCE_CAPTURE to Verbose, run the task again then check the task  This means that in the event of primary server failure and promotion of a standby to primary, the replication slots will persist and the former-

Share

Share

Link

Turn off sharing Copy link

See all details