"Martin Langhoff" <martin.langhoff@xxxxxxxxx> writes: > I have been following and experimenting a bit with PITR for a while, > and I wonder whether it is practical to use the PITR hooks to roll > back the database to a known state. The scenario is that I am > developing a script that will be massaging data in a medium size > database. A pg_restore of the pristine data takes ~35 minutes to > complete, if I can take a snapshot right after pg_restore, and use it > to later "rewind" to that point, I'll save 35 minutes every time I > need to test it. 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. regards, tom lane
