PITR Questions

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: PITR Questions
Date: 2006-08-03 21:03:35
Message-ID: 44D264A7.8040801@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm setting up PITR for a client and have a few questions.

I have done some googling for real world archive_command examples and
haven't really found anything. The example in the PGSQL Docs are
qualified by (This is an example, not a recommendation, and may not work
on all platforms.)

I have it set as follows:
archive_command = 'rsync -a %p backup_server:/pgsql_pitr/%f'

Any comments as to whether or not this is a *good* choice?

Also, I'm concerned that this clients website has extended periods of
time where it's very low traffic, which will result in the same WAL file
being used for long periods of time and not getting archived. Does
anyone have a tested script available for grabbing the most recent WAL
file? I can write one myself, but it seems this is information that
should be posted somewhere.

Thanks,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2006-08-03 21:15:49 Re: SAVEPOINT and FOR UPDATE
Previous Message Joe Audette 2006-08-03 20:45:19 Re: Well, Pervasive is now out....