Re: PITR - "Rewind to snapshot" scheme

Or use a SAVEPOINT. I don't know about the impact on resources if you
leave it hanging around for a long time, but I use these for exactly
the scenario you are talking about.

- Ian

On 4/16/07, Martin Langhoff <martin(dot)langhoff(at)gmail(dot)com> wrote:
> On 4/17/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Seems overly complicated --- why don't you just shut down the postmaster
> > and take a tarball archive of the PGDATA tree? Then to revert, stop
> > postmaster and untar.
>
> Thanks for the tip!
>
> cheers
>
>
> martin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>