On Aug 9, 2006, at 10:31 PM, Matthew T. O'Connor wrote:
Jim C. Nasby wrote:
Take a look at http://pgfoundry.org/projects/pgpitrha/
I had already seen this however it says that this project has yet
to release any files, so I thought it was a dead project. Am I
missing something?
No, the
Jim C. Nasby wrote:
Take a look at http://pgfoundry.org/projects/pgpitrha/
I had already seen this however it says that this project has yet to
release any files, so I thought it was a dead project. Am I missing
something?
Also, note that in 8.1, you have to manually archive the last WAL
On Fri, Aug 04, 2006 at 03:46:09PM -0400, Matthew T. O'Connor wrote:
> Chander Ganesan wrote:
> >Matthew T. O'Connor wrote:
> >>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
> I don't see how checkpoint_timeout is relevant. Just because we
> checkpoint doesn't mean the WAL file will get archived. I have to have
> 16M of WAL traffic before a file gets archived regardless of
> check-pointing, or am I missing something?
Right, I think ;-) If you want finer-grained back
Wayne Conrad wrote:
On Fri, Aug 04, 2006 at 11:04:03AM -0400, Matthew T. O'Connor wrote:
Wayne Conrad wrote:
Are you also doing the dance with pg_start_backup(), doing a file copy
Yes, of course. Is there another way?
Not that I know of. I'm embarassed I ask, since you
On Fri, Aug 04, 2006 at 11:04:03AM -0400, Matthew T. O'Connor wrote:
> Wayne Conrad wrote:
> >Are you also doing the dance with pg_start_backup(), doing a file copy
>
> Yes, of course. Is there another way?
Not that I know of. I'm embarassed I ask, since you know what you're
doing.
Way
Chander Ganesan wrote:
Matthew T. O'Connor wrote:
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
Wayne Conrad wrote:
On Thu, Aug 03, 2006 at 05:03:35PM -0400, Matthew T. O'Connor wrote:
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?
Are you also doing the dance with pg_start_backup(
On Thu, Aug 03, 2006 at 05:03:35PM -0400, Matthew T. O'Connor wrote:
> 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?
Are you also doing the dance with pg_start_backup(), doing a file copy
of
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 hav
I have been experimenting with PITR (8.0 beta5), and I have a few
questions.
I started with a fresh cluster (did initdb on data). Then I did the
following sequence of things:
(01) Set in pg_hba.conf:
archive_command = 'test ! -f /archive/%f && cp -f
%p /archive/%f'
(02) start pos
11 matches
Mail list logo
