Обсуждение: [GENERAL] Cannot recover from backup on barman
Hello everyone,
I need to recover some partial data from a old backup.
The recover went smoothly up until the time to start the server, I cannot start the server.
LOG: invalid primary checkpoint record
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 30975) was terminated by signal 6: Aborted
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.
Regards,
Alfredo Palhares
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. I don't understand why Postgres-XC is part of this discussion as pg_resetxlog is part of PostgreSQL. > 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
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_ 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@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