From: | Chris <springer(dot)christoph(at)googlemail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes |
Date: | 2010-08-06 08:14:19 |
Message-ID: | 4e8b409e-a55c-4614-9482-e10de45221ff@f6g2000yqa.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi all,
the procedure that waits for the checkpoint location change looks
like::
function wait_for_checkpoint_location_change() {
PRE_WAIT=$( pg_controldata $PGDATA | awk -F: '/Latest checkpoint
location/ { print $2 }' )
log "Waiting for checkpoint"
while true ; do
sleep 5
if [[ "$PRE_WAIT" != "$( pg_controldata $PGDATA | awk -F: '/
Latest checkpoint location/ { print $2 }' )" ]] ; then
log "Checkpoint."
return
fi
done
}
The grandchild database log has the following records about the
recovery process::
2010-08-06 09:48:31.266 CEST,,,30649,,4c5bbe46.77b9,15,,2010-08-06
09:48:22 CEST,,0,LOG,00000,"restored log file
""000000010000005B000000DC"" from archive",,,
,,,,,,""
2010-08-06 09:48:31.564 CEST,,,30649,,4c5bbe46.77b9,16,,2010-08-06
09:48:22 CEST,,0,LOG,00000,"consistent recovery state reached at 5B/
DD000000",,,,,,,,,""
2010-08-06 09:48:31.751 CEST,,,30649,,4c5bbe46.77b9,17,,2010-08-06
09:48:22 CEST,,0,LOG,00000,"restored log file
""000000010000005B000000DD"" from archive",,,
,,,,,,""
Regards,
-- Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Heikens | 2010-08-06 11:10:13 | BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same |
Previous Message | Adam Radlowski | 2010-08-06 08:12:08 | BUG #5605: round(attr_name,int) works bad |