Multiple Bart Restores

SOLVED
Highlighted
Silver Adventurer

Multiple Bart Restores

Curious how timelines would handle restoring a system to the same time,  multiple times.

 

Is this possible,  if you restore to tuesday 10:30am  on server01 and then on wednesday,  you restore to the same system server01 again with that same time of tuesday 10:30am,

 

how would the timeline files handle this,  

 

I am asking as i have attempted this and my wals files are not replaying to the time i have specified.

 

matt

 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
EDB Team Member

Re: Multiple Bart Restores

Hi Matt,

 

Could you please elaborate your requiremnt in more detail, what eactly your trying to achive.

 

If I understand correctly your trying to restore a backup of tuesday 10:30 AM on server01 and next day wednesday on same server01 you are trying to restore backup of tuesday 10:30 AM. It is not possible because your server01 is already ahead.

 

On wednesday on server01, If you delete the restored cluster of tuesday 10:30 AM which you performed on tuesday on server01 and then you can restore the same backup of tuesday 10:30 AM on server01.

 
 
 

View solution in original post

1 REPLY 1
Highlighted
EDB Team Member

Re: Multiple Bart Restores

Hi Matt,

 

Could you please elaborate your requiremnt in more detail, what eactly your trying to achive.

 

If I understand correctly your trying to restore a backup of tuesday 10:30 AM on server01 and next day wednesday on same server01 you are trying to restore backup of tuesday 10:30 AM. It is not possible because your server01 is already ahead.

 

On wednesday on server01, If you delete the restored cluster of tuesday 10:30 AM which you performed on tuesday on server01 and then you can restore the same backup of tuesday 10:30 AM on server01.

 
 
 

View solution in original post

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks