April 25, 2006
Saving your bacon with a PostgreSQL Restore File
Last week our "junior" dba did an unconstrained update (ie. no where clause) on a table in production. Rather than resorting to physical punishment, I figured I ought to fix the thing first. We don't use PITR on this system, but luckily we do have nightly backups and the data in question rarely changes; in a lot of other scenarios we would be screwed... still I thought the post mortem might be an interesting read, so here it is.