Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL backup idea

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 (view raw or flat)
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

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2010-01-20 11:48:23
Subject: Re: PostgreSQL backup idea
Previous:From: Renato OliveiraDate: 2010-01-20 09:24:57
Subject: PostgreSQL backup idea

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group