Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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
5  
yea start typing. –  tony roth Oct 5 '11 at 13:47
1  
Y U NO BACKUP?? –  GregD Oct 5 '11 at 14:11

2 Answers 2

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  
+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

 
discard

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.