From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: question about replication slots |
Date: | 2015-12-06 16:28:26 |
Message-ID: | 20151206162826.GA2615@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Michael Paquier <michael(dot)paquier(at)gmail(dot)com> wrote:
> On Sat, Dec 5, 2015 at 2:35 AM, Andreas Kretschmer
> <andreas(at)a-kretschmer(dot)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°
From | Date | Subject | |
---|---|---|---|
Next Message | Blake McBride | 2015-12-06 21:30:33 | Generating an XSD file from an existing database |
Previous Message | Michael Paquier | 2015-12-06 14:08:36 | Re: question about replication slots |