On Tue, Nov 10, 2009 at 9:52 AM, Greg Stark <gsst...@mit.edu> wrote:
>
> It's always worth having the dump, even if you also implement PITR.
> The dump allows you to restore just specific tables or to restore onto
> a different type of system. The PITR backup is a physical
> byte-for-byte copy which only works if you restore the whole database
> and only on the same type of system.
>
Good point here, you really should have a 'logical' copy of your
database around in case there is some kind of physical corruption in
addition to Greg's good points.
--Scott
