| From: | Jesper Krogh <jesper(at)krogh(dot)cc> |
|---|---|
| To: | Renato Oliveira <renato(dot)oliveira(at)grant(dot)co(dot)uk> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL backup idea |
| Date: | 2010-01-20 09:34:03 |
| Message-ID: | 4B56CE0B.6070001@krogh.cc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Renato Oliveira wrote:
> Dear all,
>
> I have been thinking about PostgreSQL backup for some time now.
>
> I can't implement PITR right now on our live systems, for commercial
> reasons.
I think you need to rethink this one...
> 4 - Backup instead of time use transactionID Do a full backup, mark
> what was the last transactionID to the minute of backup finish and
> then onwards to backups only for the updated transactionIDs. For
> example: Full backup finishes at 13:00, the last transactionID at
> 13:00 would be 00013, then from 13:01 onwards backup the updates, so
> on.
This is conceptually PITR.
--
Jesper
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-01-20 11:48:23 | Re: PostgreSQL backup idea |
| Previous Message | Renato Oliveira | 2010-01-20 09:24:57 | PostgreSQL backup idea |