Michael Paquier <michael.paqu...@gmail.com> wrote: > On Sat, Dec 5, 2015 at 2:35 AM, Andreas Kretschmer > <andr...@a-kretschmer.de> wrote: > > imagine a streaming replication using physical replication slots. And > > sometime a > > fail over. All okay. I take a basebackup and rebuild the old master as > > slave. > > > > Is there a risk that the new slave contains active replication slots but no > > listener on it? > > Yes. This would retain WAL on the standby indefinitely if you are not careful. > > > What have i to consider? > > You had better remove the contents of pg_replslot/ in the backup > taken. Even if you include them, there are high chances that those > will be useless at the end. > > So, quoting the docs > (http://www.postgresql.org/docs/devel/static/continuous-archiving.html):
Thx for the answer! Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
