I have set up the replication using Bucardo. This is just an additional set up
regards On Tue, Nov 10, 2009 at 5:09 PM, silly8888 <[email protected]> wrote: > How about using replication instead of incremental backups? > > On Tue, Nov 10, 2009 at 4:56 PM, Alan Hodgson <[email protected]> wrote: > > On Tuesday 10 November 2009, akp geek <[email protected]> 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 ([email protected]) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
