| From: | Madison Kelly <linux(at)alteeve(dot)com> |
|---|---|
| To: | Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: rollback |
| Date: | 2008-07-09 15:01:46 |
| Message-ID: | 4874D2DA.5080402@alteeve.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Moisey wrote:
> Hi
>
> I would like to be able to "mark" a point in my postgres database. After
> that I want to change a few things and "rollback" to that point. Does
> postgres support such a thing? Is it possible for me to do this?
>
A crude way of doing it, which I've done in the past on test DBs, is
take periodic dumps of the DB, do some work/development, then drop the
DB and reload the dump to go back in time. Of course, this becomes less
feasible as your DB grows in size.
I've not played with savepoints myself, though if others are
recommending it, it is probably more sane then my method.
Madi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe | 2008-07-09 15:06:28 | Re: rollback |
| Previous Message | x asasaxax | 2008-07-09 15:00:05 | Table X its full, what can i do now? |