Обсуждение: pg_basebackup and replication slots
Hello, The fact that pg_basebackup doesn't use replicaiton slots, is that a technical limitation or just a, "we need a patch"? JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you.
On 26-10-2015 08:58, Joshua D. Drake wrote:
> Hello,
>
> The fact that pg_basebackup doesn't use replicaiton slots, is that a
> technical limitation or just a, "we need a patch"?
>
It is not in 9.5 but it is already there.
commit 0dc848b0314d63188919f1ce943730eac684dccd
Author: Peter Eisentraut <peter_e@gmx.net>
Date: Tue Jul 21 21:06:45 2015 -0400
pg_basebackup: Add --slot option
This option specifies a replication slot for WAL streaming (-X stream), so that there can be continuous
replicationslot use between WAL streaming during the base backup and the start of regular streaming replication.
Reviewed-by: Michael Paquier <michael.paquier@gmail.com>
-- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento,
Suporte24x7 e Treinamento
On Mon, Oct 26, 2015 at 12:58 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
Hello,
The fact that pg_basebackup doesn't use replicaiton slots, is that a technical limitation or just a, "we need a patch"?
I believe it does, but only in master so far, not even in 9.5: http://www.postgresql.org/docs/devel/static/app-pgbasebackup.html
--
Alex
On 10/26/2015 12:58 PM, Joshua D. Drake wrote:
> Hello,
>
> The fact that pg_basebackup doesn't use replicaiton slots, is that a
> technical limitation or just a, "we need a patch"?
>
Given the rest of the thread.... any possibility whatsoever that it'd be
backpatched into 9.5 before release? Guess it'd be a very welcome addition....
Thanks,
/ J.L.
On Tue, Oct 27, 2015 at 7:18 AM, José Luis Tallón wrote: > Given the rest of the thread.... any possibility whatsoever that it'd be > backpatched into 9.5 before release? > Guess it'd be a very welcome addition.... This will be available in 9.6. 9.5 is aimed at being stabilized now, so no new features are added at this point. -- Michael
On 10/26/2015 08:14 PM, Michael Paquier wrote: > On Tue, Oct 27, 2015 at 7:18 AM, José Luis Tallón wrote: >> Given the rest of the thread.... any possibility whatsoever that it'd be >> backpatched into 9.5 before release? >> Guess it'd be a very welcome addition.... > > This will be available in 9.6. 9.5 is aimed at being stabilized now, > so no new features are added at this point. > I know this isn't the answer people are looking for but it is also possible to back patch this. Of course we won't put it in the main tree but this might be something worth leaving outside (until 9.6). JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you.