Postgres online backup and restore has errors that are concerning

From: Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Postgres online backup and restore has errors that are concerning
Date: 2009-06-25 13:58:49
Message-ID: BLU149-W719B1A24BC77EE69156A6D4340@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I started an online backup of postgres, tar’d my data folder, copy to usb
drive in production
and restored it into my RC environment. Have I missed
something important?

Online
Backup

psql
checkpoint;
SELECT
pg_switch_xlog();
SELECT
pg_start_backup('postres_full_backup_June222009');
tar -czvf
pgprd01_June22_2009_production.dmp.tar.gz data/
SELECT
pg_stop_backup();

Restore
tar –xzvf
pgprd01_June22_2009_production.dmp.tar.gz

When starting the database I
receive many errors that look like the backup was
corrupted.

2009-06-23 08:29:15
EDT:@:7614ERROR: xlog flush request 10D/590D6578 is not satisfied --- flushed
only to 10D/510C4FB8
2009-06-23 08:29:15
EDT:@:7614CONTEXT: writing block 2 of relation
16403/16884/2696
2009-06-23 08:29:16
EDT:@:7614ERROR: xlog flush request 10D/590D6578 is not satisfied --- flushed
only to 10D/510C4FB8
2009-06-23 08:29:16
EDT:@:7614CONTEXT: writing block 2 of relation
16403/16884/2696
2009-06-23 08:29:16
EDT:@:7614WARNING: could not write block 2 of
16403/16884/2696

pgdb001=> select
criteria_rank from client001.t1020screen where criteria_rank like
'%TR009%';
ERROR: missing chunk number
0 for toast value 738680

Version
[postgres(at)pgprd01 data]$ cat
PG_VERSION
8.3

Chris Barnes
_________________________________________________________________
Windows Live helps you keep up with all your friends, in one place.
http://go.microsoft.com/?linkid=9660826

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2009-06-25 14:06:13 PG 8.3.7 initdb -E LATIN1 fails on Windows
Previous Message Tom Lane 2009-06-25 13:58:07 Re: Add Space symbols for TSvector