From: Simon Riggs <simon@2ndquadrant.com>
To: Eric Yum <eric.yum@ck-lifesciences.com>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL backup issue
Date: Tue, 6 Apr 2004 21:44:59 +0100
Message-ID: <KGEFLMPJFBNNLNOOOPLGGEINCHAA.simon@2ndquadrant.com> (raw)
In-Reply-To: <KGEFLMPJFBNNLNOOOPLGGEIMCHAA.simon@2ndquadrant.com>
> Eric Yum wrote
> I am using PostgreSQL 7.3 as DB server in my company. I am preparing
> some DB backup and maintenance procedures. I found from Administrator
> guide that we can use "dump" command to backup the DB. It
> just allow me
> to backup the whole DB and restore the whole DB. I wonder that is any
> command or feature in PostgreSQL allow me to have incremental backup
> policy like SQL Server. In addition, when I restore the DB, is it
> possible to select the specify time frame to restore.
I'm working on this right now; PostgreSQL community calls this Point in
Time Recovery (PITR). This will allow you to take hot backups
occasionally, then backup the transaction logs in between. You would
need to migrate to 7.5 when it becomes available approx 3 months from
now (earlier in dev versions).
The design doesn't currently offer a facility to specify the time frame
to restore. I will be recommending calculating this following the
testing of your recovery procedures. It would then be up to you to
specify appropriately spaced full database backups to give you the MTTR
you require.
[Please note that PostgreSQL does not currently support "incremental"
backup, i.e. only what has changed since last backup, nor will it when
PITR is implemented...thats something different again]
Best Regards, Simon Riggs, 2ndQuadrant
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: simon@2ndquadrant.com, eric.yum@ck-lifesciences.com
Subject: Re: PostgreSQL backup issue
In-Reply-To: <KGEFLMPJFBNNLNOOOPLGGEINCHAA.simon@2ndquadrant.com>
References: <KGEFLMPJFBNNLNOOOPLGGEIMCHAA.simon@2ndquadrant.com> <KGEFLMPJFBNNLNOOOPLGGEINCHAA.simon@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox