pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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!
>
>




view thread (4+ messages)

Message-ID: <44CF98C3.7010706@mailnetwork.co.uk>
Permalink:  ../44CF98C3.7010706@mailnetwork.co.uk/
Also on:    postgresql.org/message-id/44CF98C3.7010706@mailnetwork.co.uk

 · 

reply

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