PITR with rsync

From: David Bear <David(dot)Bear(at)asu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: PITR with rsync
Date: 2007-08-07 00:11:14
Message-ID: 20070807001114.GD19294@asu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-08-07 00:27:13 Re: PITR with rsync
Previous Message Donald Fraser 2007-08-06 23:59:31 Re: WAL segment question