| 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 |