Named restore points

Jaime Casanova <jaime@2ndquadrant.com>

From: Jaime Casanova <jaime@2ndquadrant.com>

To: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2011-01-14T20:41:39Z

Lists: pgsql-hackers

Attachments

named_restore_points.patch (text/x-patch) patch

Hi,

Here is a patch that implements "named restore points".

It allows DBAs to specify  an exact point to which they can recover
but that point will have a name, so they have a better control of when
they want to stop recovery (ie: DBA's won't depend of remember
specific times, dates and such).

This adds a new function: pg_create_restore_point(text) (i'm not
wedded with the name so if someone wants to suggest something better,
that's fine with me), a new xlog record and a new recovery_target
parameter in recovery.conf

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL