Re: question about replication slots
От | Andreas Kretschmer |
---|---|
Тема | Re: question about replication slots |
Дата | |
Msg-id | 20151206162826.GA2615@tux обсуждение исходный текст |
Ответ на | Re: question about replication slots (Michael Paquier <michael.paquier@gmail.com>) |
Список | pgsql-general |
Michael Paquier <michael.paquier@gmail.com> wrote: > On Sat, Dec 5, 2015 at 2:35 AM, Andreas Kretschmer > <andreas@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°
В списке pgsql-general по дате отправления: