Named restore points

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Named restore points
Date: 2011-01-14 20:41:39
Message-ID: AANLkTinq0kKGv3oR7jxfZ2rxdfBOJyzafPam2=j11AdU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
named_restore_points.patch text/x-patch 19.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-01-14 20:43:36 Re: Database file copy
Previous Message Kevin Grittner 2011-01-14 20:41:13 Re: Database file copy