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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to