pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jason DiCioccio <geniusj@gmail.com>
To: pgsql-admin@postgresql.org
Subject: PITR/Online Backups? When can I delete archived WAL logs?
Date: Thu, 31 Mar 2005 01:57:18 -0500
Message-ID: <89bc2a0405033022576d6536c7@mail.gmail.com> (raw)

Ok.  I have been going over the documention for PITR/Online Backups,
and it has me confused about a couple of things.  Hopefully someone
can help me. :-)

First of all, here's what I'm doing:

-- from psql
SELECT pg_start_backup('mylabel');

-- from shell
rsync --exclude $WALARCHIVEDIR $PGDATA remotehost:/dir/to/pgdata
# ignore the fact that WALARCHIVEDIR is not a real var.. it's defined
correctly in mine :-)

-- from psql
SELECT pg_stop_backup('mylabel');
rsync $WALARCHIVEDIR remotehost:/dir/to/pgsql/archive

When I do this, and throw a recovery.conf into place, it generally
spits out errors like this on the other box if I attempt to start with
this:

cp: /usr/local/pgsql/archive/00000001.history: No such file or directory
cp: /usr/local/pgsql/archive/00000001000000000000000F: No such file or directory

Do I need to backup pg_xlog?  I could have sworn it said not to. 
Also, am I doing this right at all?  Does anyone have a script they
are using for this?

Thanks in advance,
Jason DiCioccio



view thread (3+ messages)  latest in thread

Message-ID: <89bc2a0405033022576d6536c7@mail.gmail.com>
Permalink:  ../89bc2a0405033022576d6536c7@mail.gmail.com/
Also on:    postgresql.org/message-id/89bc2a0405033022576d6536c7@mail.gmail.com

 · 

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: geniusj@gmail.com
  Subject: Re: PITR/Online Backups? When can I delete archived WAL logs?
  In-Reply-To: <89bc2a0405033022576d6536c7@mail.gmail.com>
  References: <89bc2a0405033022576d6536c7@mail.gmail.com>

* 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