Re: Confused by the behavior of pg_basebackup with replication slot

From: Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>
To: "Yi, Yi" <yiy(at)cn(dot)fujitsu(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Confused by the behavior of pg_basebackup with replication slot
Date: 2016-03-19 14:58:05
Message-ID: 56ED68FD.4010102@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

On 19/03/2016 15:41, Yi, Yi wrote:
> Hello,
>
> I had an issue with the behavior of pg_basebackup command. I was convinced previously that pg_basebackup command always made the binary copy of the database cluster files of the postgres master. However, I recently noticed that pg_basebackup did not copy the the replication slot object of the master, in comparison with the fact that the copy-command-based-backup did copy the replication slot object. Is this difference designed on purpose ?
>

Yes.

> Considering the difference mentioned above, I'm wandering that is there anything else that the pg_basebackup would NOT copy from the master ?
> In other words, what is the no-copying rules of pg_basebackup ?
>

The full list is documented here:
http://www.postgresql.org/docs/current/static/protocol-replication.html

Regards.

> Any help will be greatly appreciated. Thanks.
>
> Best Regards.
>

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2016-03-19 15:01:24 Re: Confused by the behavior of pg_basebackup with replication slot
Previous Message Robert Haas 2016-03-19 14:42:51 Re: [GENERAL] Request - repeat value of \pset title during \watch interations