Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using PostgreSQL. I have 4 database servers. Each server has same database and same schema. Mistakenly I restored the database util05db backup onto the util01db database.

How can I get the util01db before restored?

share|improve this question
    
Unless you have a backup of util01db, there is nothing you can do. –  a_horse_with_no_name Jan 26 '12 at 11:52
    
I dont have util01db backup,that is why i am worried. –  Odaiah Jan 26 '12 at 11:53
    
Then you're screwed and you now know why it's vital to have a good backup strategy. –  DarkDust Jan 26 '12 at 11:59
3  
If you don't have a backup, the data wasn't apparently that important. –  a_horse_with_no_name Jan 26 '12 at 12:50
    
The data is important,but i mistakenly restored it instead of doing it on other,for the other one, i have backup –  Odaiah Jan 26 '12 at 16:04
add comment

migrated from stackoverflow.com Jan 26 '12 at 21:22

This question came from our site for professional and enthusiast programmers.

1 Answer

if you have a base backup AND full WAL archives you can use point in time recovery. Otherwise you are stuck. good luck. I hope you have something you can work with.

Otherwise you are screwed. There is no way to roll back restoring a backup in this way. If you didn't drop relations in the process you MIGHT be able to sort things out using min_xid columns on the tables. In that case you will have a lot of work.....

share|improve this answer
add comment

Your Answer

 
discard

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