Re: WAL and pg_dump - Mailing list pgsql-admin

From Simon Riggs
Subject Re: WAL and pg_dump
Date
Msg-id 1135289852.2964.542.camel@localhost.localdomain
Whole thread Raw
In response to Re: WAL and pg_dump  (Mike C <smith.not.western@gmail.com>)
Responses Re: WAL and pg_dump  (Mike C <smith.not.western@gmail.com>)
List pgsql-admin
On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote:
> On 12/22/05, Simon Riggs <simon@2ndquadrant.com> wrote:
>         On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:
>         > All the documentation I've seen for PITR points to having to
>         do a file
>         > system copy of sorts.
>
>         Yes. There's no other way, but why would you want another way?
>
> Mainly because a pg_dump backup takes up a lot less disk space than a
> filesystem copy (in my case, approx 3.5GB backup from a 25GB db).

What is your backup time in each case, and what is your recovery time?

Is space your limiting factor?

Best Regards, Simon Riggs



pgsql-admin by date:

Previous
From: Mike C
Date:
Subject: Re: WAL and pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Create Index Locking Question