From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Benjamin Arai <barai(at)cs(dot)ucr(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Syncing Databases Weekly |
Date: | 2006-02-07 17:20:57 |
Message-ID: | 43E8D6F9.6010105@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-02-07 17:38:25 | Re: what is the data type for files(.txt,.doc,.jpeg) in pgsql |
Previous Message | SCassidy | 2006-02-07 17:13:46 | Re: what is the data type for files(.txt,.doc,.jpeg) in |