Re: Syncing Databases Weekly - Mailing list pgsql-general

From Richard Huxton
Subject Re: Syncing Databases Weekly
Date
Msg-id 43E8D6F9.6010105@archonet.com
Whole thread Raw
In response to Syncing Databases Weekly  ("Benjamin Arai" <barai@cs.ucr.edu>)
List pgsql-general
Benjamin Arai wrote:
> Hi,
>
> I am familiar with applications like slony for replications, I am looking
> for a technique for syncing a very large database every week for backup and
> redundancy purposes.  More specifically, I do all my writes to a main server
> once a week, at the end of the updates I would like to automatically copy
> all of the data to a second server as a live backup in case the main system
> ever goes down.

PITR (Point In Time Recovery) - details in the manuals and recently
discussed on one of the lists.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Nikolay Samokhvalov
Date:
Subject: Re: Sequences/defaults and pg_dump
Next
From: SCassidy@overlandstorage.com
Date:
Subject: Re: what is the data type for files(.txt,.doc,.jpeg) in