From: David Bear <David.Bear@asu.edu>
To: pgsql-admin@postgresql.org
Subject: PITR with rsync
Date: Mon, 6 Aug 2007 17:11:14 -0700
Message-ID: <20070807001114.GD19294@asu.edu> (raw)
I've been looking at the pages on PITR and am wondering if anyone has
tried using rsync to accomplish this.
I'm still uncomfortable with using the file system style backup method
in PITR and am very interested in ' more information ' on how others
may be doing backups. Specifically, I assume that PITR methods would
also be accompanied with some combination of pg-dump. I am curious
about how frequently a pg-dump would be done if a PITR method was also
used (every 24 hours, every 7 days, not at all ) ??
Also, looking at the archive_command argument in postgresql.conf. Has
anyone use rsync there?
--
David Bear
phone: 602-496-0424
fax: 602-496-0955
College of Public Programs/ASU
University Center Rm 622
411 N Central
Phoenix, AZ 85007-0685
"Beware the IP portfolio, everyone will be suspect of trespassing"
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: David.Bear@asu.edu
Subject: Re: PITR with rsync
In-Reply-To: <20070807001114.GD19294@asu.edu>
* 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