From: Kevin Grittner <kgrittn@ymail.com>
To: Guillaume Lelarge <guillaume@lelarge.info>
To: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
Cc: Keith <keith@keithf4.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Automatic restore corruption problem
Date: Thu, 16 Jul 2015 18:39:34 +0000 (UTC)
Message-ID: <715399565.355625.1437071974784.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <CAECtzeVB+28FXvNW=51wiqQVrNaNEu1iZ-LOnGyafJvnWxXrzw@mail.gmail.com>
References: <CAECtzeVB+28FXvNW=51wiqQVrNaNEu1iZ-LOnGyafJvnWxXrzw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Guillaume Lelarge <guillaume@lelarge.info> wrote:
> There were two issues on your script: it removed the backup_label
> file and didn't create the recovery.conf file.
There were more flaws in the script than that. See:
http://www.postgresql.org/docs/current/static/continuous-archiving.html#BACKUP-PITR-RECOVERY
That says, in part:
| Remove any files present in pg_xlog/; these came from the file
| system backup and are therefore probably obsolete rather than
| current.
The point is, if you are unfortunate enough to have recovery use
one of the WAL files copied during the backup, it might not be
complete, since they may have been copied at any point in the
backup -- quite likely before all the WAL records needed for
reaching consistency were added. The archived WAL files will be
complete; set up the recovery.conf file to use them.
Elsewhere on that page it says:
| You might also want to exclude postmaster.pid and
| postmaster.opts, which record information about the running
| postmaster, not about the postmaster which will eventually use
| this backup. (These files can confuse pg_ctl.)
If these files are removed, it is much harder to accidentally bring
up the database with corruption.
> Did you fix this? if yes, can you send back your script? Thanks.
Yeah, if you think you are now following the instructions shown at
the link I show above and are still having problems, please show
all steps in the process -- copy and paste scripts and commands,
and the relevant portions of logs.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kgrittn@ymail.com, guillaume@lelarge.info, matthieu.lejeune@exxoss.com, keith@keithf4.com
Subject: Re: Automatic restore corruption problem
In-Reply-To: <715399565.355625.1437071974784.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox