| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Anj Adu <fotographs(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: advanced backup tool |
| Date: | 2010-05-14 20:28:52 |
| Message-ID: | 201005142028.o4EKSqR17940@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Anj Adu wrote:
> Will any upcoming release of Postgres have an incremental backup tool
> like Oracle's RMAN? Currently, the WAL based archiving requires many
> frequent full backups (especially for large databases) as the replay
> of a large number of WAL files will take a very long time. We have a
> few databases each over 1Tb and are looking for effective
> backup/recovery strategies. (Currently..we rely on specific partition
> backups via COPY command)...but the process is cumbersome.
>
> RMAN's incremental backup effectively makes every incremental backup a
> full backup which is a great time-saver during recovery.
Sure, look at pg-rman:
http://code.google.com/p/pg-rman/
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anj Adu | 2010-05-14 20:43:49 | Re: advanced backup tool |
| Previous Message | Marc G. Fournier | 2010-05-14 20:21:38 | Re: [HACKERS] List traffic |