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 <silly8...@gmail.com> wrote: > 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 >
