Обсуждение: PostgreSQL backup issue

> 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

At this time, we do not have point in time recovery.  That is slated for 7.5 (we hope).  There is also no way to
performincremenatals (yet). 
    -----Original Message-----
    From: pgsql-admin-owner@postgresql.org on behalf of Eric Yum
    Sent: Mon 4/5/2004 7:34 PM
    To: pgsql-admin@postgresql.org
    Cc:
    Subject: [ADMIN] PostgreSQL backup issue


    Dear all

    I am using PostgreSQL 7.3 as DB server in my company. I am preparing some DB backup and maintenance procedures. I
foundfrom Administrator guide that we can use “dump” command to backup the DB. It just allow me to backup the whole DB
andrestore the whole DB. I wonder that is any command or feature in PostgreSQL allow me to have incremental backup
policylike SQL Server. In addition, when I restore the DB, is it possible to select the specify time frame to restore.  

    Million Thanks.

    Best Regards,
    Eric Yum


-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain
informationthat is privileged, confidential and exempt from disclosure under applicable law. If you are not the
intendedaddressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use,
copy,disclose or distribute to anyone the message or any information contained in the message. If you have received
thismessage in error, please immediately advise the sender by reply email, and delete the message. Thank you.