Re: Including replication slot data in base backups - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Including replication slot data in base backups
Date
Msg-id D2F8C9799F9B34D41E3E5D62@apophis.credativ.lan
Whole thread Raw
In response to Re: Including replication slot data in base backups  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers

--On 1. April 2014 11:26:08 -0400 Robert Haas <robertmhaas@gmail.com> wrote:

>
> As a general comment, I think that replication slots, while a great
> feature, have more than the usual potential for self-inflicted injury.
>  A replication slot prevents the global xmin from advancing (so your
> tables will bloat) and WAL from being removed (so your pg_xlog
> directory will fill up and take down the server).  The very last thing
> you want to do is to keep around a replication slot that should have
> been dropped, and I suspect a decent number of users are going to make
> that mistake, just as they do with prepared transactions and backends
> left idle in transaction.

Oh yes, i saw this happening uncountless times now by customers when 
restoring a basebackup with in-progress prepared xacts (and was indeed 
fooled myself a few times, too). I always was under the impression that 
there should be a big big warning at least in the logs to hint the user to 
check any remaining prepared xacts...

-- 
Thanks
Bernd



pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: using arrays within structure in ECPG
Next
From: Andres Freund
Date:
Subject: Re: Including replication slot data in base backups