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

migrated from Jan 26 '12 at 21:22

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

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

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


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