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

view thread (2+ messages)  latest in thread

Message-ID: <478671A9.9070404@computer.org>
Permalink:  ../478671A9.9070404@computer.org/
Also on:    postgresql.org/message-id/478671A9.9070404@computer.org

 · 

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 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