hi mr d,
yes i would say you have a problem with the 8.1.4's archive-command -
sorry most of my keyboard keys have stopped working so i can't use
capitals or punctuation lol.
check your latest logs on the 8.1.4 server for errors in archiving that
file. when you've done a backup, that .backup file should be archived
with the archive-command, the same as the normal wal logs - the
.backup.done file is not written because postgres couldn't archive the
file for some reason - check your logs is about the best i can advise.
sorry for the amateurish email - i'm off to replace my keyboard
andy.
Mr. Dan wrote:
Hey Andy,
Sorry for the confusion. That file and the one in archive_status
(*.backup.done) are from v810. I'm wondering why my PITR backup in
v814 doesn't leave me with similiear files. Neither *.backup in
pg_xlog or *.backup.done in archive_status shows up. I was wondering
if that was by design or I have a problem.
~DjK
From: Andy Shellam <andy.shellam-lists@xxxxxxxxxxxxxxxxx>
Reply-To: Andy Shellam <andy.shellam-lists@xxxxxxxxxxxxxxxxx>
To: "Mr. Dan" <bitsandbytes88@xxxxxxxxxxx>
CC: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [ADMIN] online backup - v810 vs. v814
Date: Tue, 01 Aug 2006 17:05:45 +0100
That looks to be a file hanging around from a previous PITR backup.
That file should be in your xlog archive.
cat the contents and you'll see which backup it belongs to.
Andy.
Mr. Dan wrote:
Hi,
I do an online backup with v814 and v810. I've noticed that there
is a file showing up in the PGDATA
directory/pg_xlog/00000000010000251000000C2.0021CDDE.backup owned by
postgres 284 bytes in size that shows up in v810. That file isn't
showing up in v814. Is that by design?
~DjK
psql -d somedb "SELECT pg_start_backup()
---------------------------(end of
broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
!DSPAM:37,44cf9118143292966821177!
