Thread: pg_basebackup and replication slots

pg_basebackup and replication slots

From
"Joshua D. Drake"
Date:
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.



Re: pg_basebackup and replication slots

From
Euler Taveira
Date:
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
 



Re: pg_basebackup and replication slots

From
"Shulgin, Oleksandr"
Date:
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

Re: pg_basebackup and replication slots

From
José Luis Tallón
Date:
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.




Re: pg_basebackup and replication slots

From
Michael Paquier
Date:
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



Re: pg_basebackup and replication slots

From
"Joshua D. Drake"
Date:
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.