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@mailnetwork.co.uk>
>> Reply-To: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
>> To: "Mr. Dan" <bitsandbytes88@hotmail.com>
>> 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,44cf9118143292966821177!
>
>