Re: Add hint about replication slots when nearing wraparound

Feike Steenbergen <feikesteenbergen@gmail.com>

View thread

From: Feike Steenbergen <feikesteenbergen@gmail.com>

To: Michael Paquier <michael.paquier@gmail.com>

Cc: Robert Haas <robertmhaas@gmail.com>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>

Date: 2017-12-20T13:00:42Z

Lists: pgsql-hackers

Attachments

0002-Add-hint-about-replication-slots-for-wraparound.patch (application/octet-stream) patch 0002

On 20 December 2017 at 06:22, Michael Paquier <michael.paquier@gmail.com>
wrote:
> prepare_transaction.sgml has a "Caution" block mentioning that it is
> unwise to keep 2PC transactions unfinished for a too-long time as it
> interferes with VACUUM. In doc/src/sgml/logicaldecoding.sgml, it would
> be nice to add the a similar caution notice about replication slots so
> as users can get be warned before a wraparound shows up.

Added.

As far as I know the issue only occurs for stale replication slots for
logical decoding
but not for physical replication, is that correct?