pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedonline backup - v810 vs. v814
4+ messages / 2 participants
[nested] [flat]
* online backup - v810 vs. v814
@ 2006-08-01 15:58 Mr. Dan <bitsandbytes88@hotmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Mr. Dan @ 2006-08-01 15:58 UTC (permalink / raw)
To: pgsql-admin
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()
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: online backup - v810 vs. v814
@ 2006-08-01 16:05 Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
parent: Mr. Dan <bitsandbytes88@hotmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Andy Shellam @ 2006-08-01 16:05 UTC (permalink / raw)
To: Mr. Dan <bitsandbytes88@hotmail.com>; +Cc: pgsql-admin
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!
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: online backup - v810 vs. v814
@ 2006-08-01 17:36 Mr. Dan <bitsandbytes88@hotmail.com>
parent: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
0 siblings, 1 reply; 4+ messages in thread
From: Mr. Dan @ 2006-08-01 17:36 UTC (permalink / raw)
To: pgsql-admin; +Cc: andy.shellam-lists@mailnetwork.co.uk
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,44cf7a71143292031717456!
>>
>>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: online backup - v810 vs. v814
@ 2006-08-01 18:09 Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
parent: Mr. Dan <bitsandbytes88@hotmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Andy Shellam @ 2006-08-01 18:09 UTC (permalink / raw)
To: Mr. Dan <bitsandbytes88@hotmail.com>; +Cc: pgsql-admin
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!
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-08-01 18:09 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-01 15:58 online backup - v810 vs. v814 Mr. Dan <bitsandbytes88@hotmail.com>
2006-08-01 16:05 ` Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
2006-08-01 17:36 ` Mr. Dan <bitsandbytes88@hotmail.com>
2006-08-01 18:09 ` Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
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