PostgreSQL backup issue

[Eric Yum]

Dear all

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.

Million Thanks.

Best Regards,
Eric Yum

[Simon Riggs]

Post by Eric Yum
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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Naomi Walker]

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 perform incremenatals (yet).
-----Original Message-----
From: pgsql-admin-***@postgresql.org on behalf of Eric Yum
Sent: Mon 4/5/2004 7:34 PM
To: pgsql-***@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 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.

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 information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, 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 this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings