Tell me more ×
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.
up vote 2 down vote favorite

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

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

1 Answer

up vote 1 down vote

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

Your Answer

 
discard

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