Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have made some unfortunate UPDATE on a Postgresql table. Is it possible to reverse that change without any backup / rollback save etc?

share|improve this question
yea start typing. – tony roth Oct 5 '11 at 13:47
Y U NO BACKUP?? – GregD Oct 5 '11 at 14:11

NO. You've just moved to admin category which makes backups.

share|improve this answer
funny but not funny.... – tony roth Oct 5 '11 at 15:07
+1 for learning the hard way – BoyMars Oct 5 '11 at 15:11
Im not an admin of that server :D If i were i would have a backup ;; – Gosu Oct 6 '11 at 6:49

You could restore it by dropping the table (make sure link from other tables aren't connected to it) and applying the SQL script that was created before you made the update. In other words, use the previous script and apply it. If you don't have a previous script, start writing it out so it is exactly the way the table was before you applied this 'unfortunate' update. Good luck!

share|improve this answer
Uhm.. A script usually creates the table scheme, not the data in the table.. – pauska Oct 5 '11 at 14:21
Why would you drop the whole table? – GregD Oct 5 '11 at 14:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.