From: Tom Lane <tgl@sss.pgh.pa.us>
To: Imre Oolberg <imre@auul.pri.ee>
Cc: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Date: Mon, 03 Jan 2011 15:24:26 -0500
Message-ID: <24373.1294086266@sss.pgh.pa.us> (raw)
In-Reply-To: <4D222E45.2080701@auul.pri.ee>
References: <AANLkTikY_XJ0Ok7bLGVxXXfGgenfnzJ4RnSiM_H40FCM@mail.gmail.com>
<4D2213EB.7090700@auul.pri.ee>
<42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com>
<22500.1294080152@sss.pgh.pa.us>
<E486B5B1-EC5F-4615-8633-D89CF6665663@elevated-dev.com>
<22730.1294081008@sss.pgh.pa.us>
<4D222E45.2080701@auul.pri.ee>
Imre Oolberg <imre@auul.pri.ee> writes:
> First of all, thanks for your time dealing with my situation. I must
> stress that i have wal arhived starting from before issuing
> pg_start_backup, wal archives generated before pg_start/stop_backup and
> also some wal archive files generated after pg_stop_backup (and
> permissions are ok). But for some reason my replay starts exactly where
> .backup file says 'stop wal location', referring to my earlier post
> STOP WAL LOCATION: 1/6325B2E0 (file 000000010000000100000063)
> I am starting to think more in the direction what Kevin Grittner
> suggested that i miss something in my procedure and instead following so
> to say recovery path i am doing something else which strangely ends up
> with working database process but actually misses some data.
I wonder whether you're failing to copy the backup_label file as part of
the base backup. The presence of that file is what tells the slave
postmaster where it has to start recovering from.
regards, tom lane
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: tgl@sss.pgh.pa.us, imre@auul.pri.ee, scott_ribe@elevated-dev.com
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
In-Reply-To: <24373.1294086266@sss.pgh.pa.us>
* 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