Fwd: Cannot recover from backup on barman

[Alfredo Palhares <alfredo@xxxxxxxxxxx>]

Sorry this message got out of the list. 

---------- Forwarded message ----------
From: Alfredo Palhares <alfredo@xxxxxxxxxxx>
Date: Wed, Jan 4, 2017 at 11:59 AM
Subject: Re: Cannot recover from backup on barman
To: Michael Paquier <michael.paquier@xxxxxxxxx>

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_resetxlog.1.gz

manpages-zh: /usr/share/man/zh_TW/man1/pg_resetxlog.1.gz

postgres-xc: /usr/bin/pg_resetxlog

postgres-xc: /usr/share/locale/cs/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/de/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/es/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/fr/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/it/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/ja/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/ko/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/pl/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/ro/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/ru/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/tr/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/locale/zh_TW/LC_MESSAGES/pg_resetxlog-9.2.mo

postgres-xc: /usr/share/man/man1/pg_resetxlog.1.gz

postgres-xc-dbg: /usr/lib/debug/usr/bin/pg_resetxlog

postgresql-9.3: /usr/lib/postgresql/9.3/bin/pg_resetxlog

postgresql-9.3: /usr/share/postgresql/9.3/man/man1/pg_resetxlog.1.gz

postgresql-9.3-dbg: /usr/lib/debug/usr/lib/postgresql/9.3/bin/pg_resetxlog

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@xxxxxxxxx> wrote:

On Tue, Jan 3, 2017 at 12:20 AM, Alfredo Palhares <alfredo@xxxxxxxxxxx> 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