On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote:
> On 12/22/05, Simon Riggs <simon(at)2ndquadrant(dot)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
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-12-22 23:21:38|
|Subject: Re: Create Index Locking Question |
|Previous:||From: Mike C||Date: 2005-12-22 21:09:28|
|Subject: Re: WAL and pg_dump|