On 12/23/2016 02:59 PM, Stephen via talk wrote:

With the discussion about backups, I would like to raise a question I have had for some time.

Having backups does no good if you cannot restore them. Files are rather easy to test.

But how do you test restoring a database?

I back it up with the usual tool. I have the docs to do the restore.

But how to test to make sure that restoring works, without clobbering the active database?

Thank you

you can recover on a different machine or start a second instance of the database on different ports.
This is the kind of place where virtualization or containerization comes in handy.

Testing your backups is always a good idea.

-- 
Alvin Starr                   ||   voice: (905)513-7688
Netvel Inc.                   ||   Cell:  (416)806-0133
alvin@netvel.net              ||

---
Talk Mailing List
talk@gtalug.org
https://gtalug.org/mailman/listinfo/talk