Fwd: [GENERAL] Cannot recover from backup on barman
| От | Alfredo Palhares |
|---|---|
| Тема | Fwd: [GENERAL] Cannot recover from backup on barman |
| Дата | |
| Msg-id | CACrzeDH89Dzi-=Ld29JfYQHFQqJeDoxJV=8751U-B8zbK-n2pg@mail.gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] Cannot recover from backup on barman (Alfredo Palhares <alfredo@palhares.me>) |
| Список | pgsql-general |
Sorry this message got out of the list.
---------- Forwarded message ----------
From: Alfredo Palhares <alfredo@palhares.me>
Date: Wed, Jan 4, 2017 at 11:59 AM
Subject: Re: [GENERAL] Cannot recover from backup on barman
To: Michael Paquier <michael.paquier@gmail.com>
From: Alfredo Palhares <alfredo@palhares.me>
Date: Wed, Jan 4, 2017 at 11:59 AM
Subject: Re: [GENERAL] Cannot recover from backup on barman
To: Michael Paquier <michael.paquier@gmail.com>
Hello Michael,
I don't understand why Postgres-XC is part of this discussion as
pg_resetxlog is part of PostgreSQL.
Well I did an apt-file search pg_resetxlog and this is what I found:
manpages-zh: /usr/share/man/zh_CN/man1/pg_
manpages-zh: /usr/share/man/zh_TW/man1/pg_
postgres-xc: /usr/bin/pg_resetxlog
postgres-xc: /usr/share/locale/cs/LC_
postgres-xc: /usr/share/locale/de/LC_
postgres-xc: /usr/share/locale/es/LC_
postgres-xc: /usr/share/locale/fr/LC_
postgres-xc: /usr/share/locale/it/LC_
postgres-xc: /usr/share/locale/ja/LC_
postgres-xc: /usr/share/locale/ko/LC_
postgres-xc: /usr/share/locale/pl/LC_
postgres-xc: /usr/share/locale/pt_BR/LC_
postgres-xc: /usr/share/locale/ro/LC_
postgres-xc: /usr/share/locale/ru/LC_
postgres-xc: /usr/share/locale/tr/LC_
postgres-xc: /usr/share/locale/zh_CN/LC_
postgres-xc: /usr/share/locale/zh_TW/LC_
postgres-xc: /usr/share/man/man1/pg_
postgres-xc-dbg: /usr/lib/debug/usr/bin/pg_
postgresql-9.3: /usr/lib/postgresql/9.3/bin/
postgresql-9.3: /usr/share/postgresql/9.3/man/
postgresql-9.3-dbg: /usr/lib/debug/usr/lib/
I did use barman recover to recover the directory.
The backup_label file is there, and these are the contents:
START WAL LOCATION: 1BE/7B0000A0 (file 00000001000001BE0000007B)
CHECKPOINT LOCATION: 1BE/7B6CB130
BACKUP METHOD: pg_start_backup
BACKUP FROM: master
START TIME: 2016-10-26 08:01:46 UTC
LABEL: Barman backup thingie 20161026T080002
Where should I look for said file to check if its there,
On Tue, Jan 3, 2017 at 12:52 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Tue, Jan 3, 2017 at 12:20 AM, Alfredo Palhares <alfredo@palhares.me> wrote:
> Well after some research, I was suggested to use the pg_resetxlog tool from
> postgres-xc, but people also advise against it.
> Can anyone show me how to properly identify the problem with my backup? I am
> also worried that my backups are not being properly made.
You may want to see that with the maintainers of barman, they are
likely looking at this list. But here is a guess: the backup_label
file has been removed.
--
Michael
В списке pgsql-general по дате отправления: