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