If you don't test, you will have a Schrödinger's backup: both valid and invalid at the same time, until you try a restore.
On Dec 23, 2016 6:20 PM, "Alvin Starr via talk" <[email protected]> wrote: > 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 <(905)%20513-7688> > Netvel Inc. || Cell: (416)806-0133 > <(416)%20806-0133>[email protected] || > > > --- > Talk Mailing List > [email protected] > https://gtalug.org/mailman/listinfo/talk > >
--- Talk Mailing List [email protected] https://gtalug.org/mailman/listinfo/talk
