On Wed, 2004-02-11 at 19:41, Tom Lane wrote:
> Anyway, I'm hoping to see some discussion of what to do next and what
> the PITR functionality ought to look like from a user's standpoint.
As previously discussed on general ...
* WAL files archived to a different location instead of recycling.
* The ability to force a WAL log switch to ensure all changes during the
backup are flushed to archived logs and copied.
* Ability to easily apply WAL logs to a standby database. I'd love be
able to take a hot backup of my production database, bring it up on
another computer and keep it a log or two behind production by
continually copying and applying logs to it.
* Although not PITR, on a related note, having the ability to do
incremental pg_dumps would be a huge boon for those relying on pg_dumps
for backups.
* Oracle 10g's Flashback feature is interesting. You can roll the
entire database back to a point in time with:
> flashback database to '3:00 pm';
I would have to say it's hardly critical. :)