On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote: > On 12/22/05, Simon Riggs <simon@xxxxxxxxxxxxxxx> 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
