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 <[EMAIL PROTECTED]>
Reply-To: Andy Shellam <[EMAIL PROTECTED]>
To: "Mr. Dan" <[EMAIL PROTECTED]>
CC: pgsql-admin@postgresql.org
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,44cf7a71143292031717456!
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
