pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPITR/Online Backups? When can I delete archived WAL logs?
3+ messages / 2 participants
[nested] [flat]
* PITR/Online Backups? When can I delete archived WAL logs?
@ 2005-03-31 06:57 Jason DiCioccio <geniusj@gmail.com>
2005-04-03 04:18 ` Re: PITR/Online Backups? When can I delete archived WAL logs? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Jason DiCioccio @ 2005-03-31 06:57 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PITR/Online Backups? When can I delete archived WAL logs?
2005-03-31 06:57 PITR/Online Backups? When can I delete archived WAL logs? Jason DiCioccio <geniusj@gmail.com>
@ 2005-04-03 04:18 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-04-03 05:04 ` Re: PITR/Online Backups? When can I delete archived WAL logs? Jason DiCioccio <geniusj@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2005-04-03 04:18 UTC (permalink / raw)
To: Jason DiCioccio <geniusj@gmail.com>; +Cc: pgsql-admin
Jason DiCioccio <geniusj@gmail.com> writes:
> 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
Are you sure these represent problems? Note the point in the manual
that the restore_command *will* be asked for files that are not present.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PITR/Online Backups? When can I delete archived WAL logs?
2005-03-31 06:57 PITR/Online Backups? When can I delete archived WAL logs? Jason DiCioccio <geniusj@gmail.com>
2005-04-03 04:18 ` Re: PITR/Online Backups? When can I delete archived WAL logs? Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-04-03 05:04 ` Jason DiCioccio <geniusj@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jason DiCioccio @ 2005-04-03 05:04 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Tom,
Sorry.. I sent this a while ago (before my previous message). It was just
sitting in the moderation queue because I was not subscribed to the list at
the time.
Please disregard it :)
Regards,
-JD-
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-04-03 05:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-31 06:57 PITR/Online Backups? When can I delete archived WAL logs? Jason DiCioccio <geniusj@gmail.com>
2005-04-03 04:18 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-04-03 05:04 ` Jason DiCioccio <geniusj@gmail.com>
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