From: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
To: Mr. Dan <bitsandbytes88@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: online backup - v810 vs. v814
Date: Tue, 01 Aug 2006 19:09:07 +0100
Message-ID: <44CF98C3.7010706@mailnetwork.co.uk> (raw)
In-Reply-To: <BAY116-F2892BD451C582A7450F9A7D15D0@phx.gbl>
References: <BAY116-F2892BD451C582A7450F9A7D15D0@phx.gbl>
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!
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: andy.shellam-lists@mailnetwork.co.uk, bitsandbytes88@hotmail.com
Subject: Re: online backup - v810 vs. v814
In-Reply-To: <44CF98C3.7010706@mailnetwork.co.uk>
References: <BAY116-F2892BD451C582A7450F9A7D15D0@phx.gbl> <44CF98C3.7010706@mailnetwork.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox