Fwd: Cannot recover from backup on barman

From: Alfredo Palhares <alfredo(at)palhares(dot)me>
To: pgsql-general(at)postgresql(dot)org
Subject: Fwd: Cannot recover from backup on barman
Date: 2017-01-04 15:45:26
Message-ID: CACrzeDH89Dzi-=Ld29JfYQHFQqJeDoxJV=8751U-B8zbK-n2pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry this message got out of the list.
---------- Forwarded message ----------
From: Alfredo Palhares <alfredo(at)palhares(dot)me>
Date: Wed, Jan 4, 2017 at 11:59 AM
Subject: Re: [GENERAL] Cannot recover from backup on barman
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)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_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(dot)paquier(at)gmail(dot)com>
wrote:

> On Tue, Jan 3, 2017 at 12:20 AM, Alfredo Palhares <alfredo(at)palhares(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2017-01-04 15:58:37 Re: COPY: row is too big
Previous Message vod vos 2017-01-04 15:21:21 Re: COPY: row is too big