From: David Wall <d.wall@computer.org>
To: pgsql-admin@postgresql.org
Subject: PITR warm-standby with 8.2 setup questions
Date: Thu, 10 Jan 2008 11:27:37 -0800
Message-ID: <478671A9.9070404@computer.org> (raw)
I'm trying to get WAL file copying working across two systems. It seems
pretty straightforward to handle this in the "archive_command" of the
primary, in which I am able to copy the files easily to a staging area
for the backup system.
On the backup system, I have the recovery.conf pointing to my script,
but I have a few questions on how that program should behave, and
whether I'd be much wiser to just use pg_standby instead of my own script.
1) I do not want to give the backup PG a file unless it's a "complete"
file. I don't want to give it one that is currently in the middle of
being transferred from the primary to the backup system (or a backup
copy that failed in the middle). Most of my files are 16777216 bytes,
so I initially checked that size. But I found that there are files with
a name like '0000000100000002000000DC.00000020.backup' that is only 272
bytes. Will that file also need to be given to PG recovery, and if so,
how are most determining if a small file is complete or just a partial
from the copy?
2) On the recovery side, the %p and %f values are giving me %p of
'pg_xlog/RECOVERYXLOG' and %f of '0000000100000003000000B1'. Can I
confirm that this means my recover program should find a file named
'0000000100000003000000B1' in my backup system's WAL archive and copy it
to the file named 'pg_xlog/RECOVERYXLOG', or should I put it into
'pg_xlog/0000000100000003000000B1'?
3) On the backup PG, is it correct that I have to remove backup_label,
postmaster.pid and pg_xlog if they are part of the or TAR backup from
the primary's PGDATA area?
Thanks,
David
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: d.wall@computer.org
Subject: Re: PITR warm-standby with 8.2 setup questions
In-Reply-To: <478671A9.9070404@computer.org>
* 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