How about using replication instead of incremental backups? On Tue, Nov 10, 2009 at 4:56 PM, Alan Hodgson <ahodg...@simkin.ca> wrote: > On Tuesday 10 November 2009, akp geek <akpg...@gmail.com> wrote: >> So Is it always good to have the backup using PG_dump instead of PITR or >> a combination of both >> > > I like to do both. Ongoing PITR, daily base backups (by updating an rsync > copy), and weekly pg_dumps that in turn go to tape. > > PITR gives a very recent restore point in the event of server loss. As > previously mentioned, the full (custom) backups let you restore individual > tables. They're also a lot smaller than base backups + WAL logs. > > -- > "No animals were harmed in the recording of this episode. We tried but that > damn monkey was just too fast." > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
