Re: BUG #13642: no backup_label file in PG_DATA after pg_stop_backup();

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #13642: no backup_label file in PG_DATA after pg_stop_backup();
Дата
Msg-id CAMkU=1wGQ3nNu8bKJpwtjCjnNUAzAT=nyp4kFXDDk6XfDJL8kg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #13642: no backup_label file in PG_DATA after pg_stop_backup();  (amir.rohan@mail.com)
Ответы Re: BUG #13642: no backup_label file in PG_DATA after pg_stop_backup();  (Amir Rohan <amir.rohan@mail.com>)
Список pgsql-bugs
On Fri, Sep 25, 2015 at 8:16 PM, <amir.rohan@mail.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13642
> Logged by:          Amir Rohan
> Email address:      amir.rohan@mail.com
> PostgreSQL version: 9.4.4
> Operating system:   Linux
> Description:
>
> SELECT pg_start_backup('backup1');
> SELECT pg_stop('backup1');
>

The backup_label file should have been created by the first of those, and
removed by the second.  It should have existed in $PGDATA between those
events, but not afterward.  Because it should have been present in $PGDATA
while it was being copied to the backup, that means it should also be
present in your backup.


>
> Doesn't create the `backup_label`  described in the docs (I'm assuming
> "cluster directory" means data directory, e.g. $PGDATA):
> http://www.postgresql.org/docs/current/static/continuous-archiving.html
>
> They further state:
> "The file is critical to the integrity of the backup, should you need to
> restore from it."
>
> Are my backups safe or not?
>
>
Is backup_label present in your *backup*?  That is where it is needed.  It
is not needed in $PGDATA itself.  It is created in $PGDATA simply so that a
copy of it gets included in your backup.

Cheers,

Jeff

В списке pgsql-bugs по дате отправления:

Предыдущее
От: amir.rohan@mail.com
Дата:
Сообщение: BUG #13644: 2xRecovery without new writes, causes archiving failure
Следующее
От: Amir Rohan
Дата:
Сообщение: Re: BUG #13642: no backup_label file in PG_DATA after pg_stop_backup();