pg_basebackup and replication slots

Started by Joshua D. Drakeabout 10 years ago6 messages
#1Joshua D. Drake
jd@commandprompt.com

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.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#2Euler Taveira
euler@timbira.com.br
In reply to: Joshua D. Drake (#1)
Re: pg_basebackup and replication slots

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 replication slot 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, Suporte 24x7 e Treinamento

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Shulgin, Oleksandr
oleksandr.shulgin@zalando.de
In reply to: Joshua D. Drake (#1)
Re: pg_basebackup and replication slots

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

#4José Luis Tallón
jltallon@adv-solutions.net
In reply to: Joshua D. Drake (#1)
Re: pg_basebackup and replication slots

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.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#5Michael Paquier
michael.paquier@gmail.com
In reply to: José Luis Tallón (#4)
Re: pg_basebackup and replication slots

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#6Joshua D. Drake
jd@commandprompt.com
In reply to: Michael Paquier (#5)
Re: pg_basebackup and replication slots

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.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers