[Info-ingres] Recover Database

[Rich Ford]

On Tuesday, 25 January 2022 at 06:12:09 UTC-8, Martin Bowes wrote:
> Hi Rich, 
> 
> Short answer: Don't. 
> 
> This is not the right way to do it as there are huge problems in getting the database to believe the checkpoint file is cool. You could end up with a very scrambled database configuration file 
> 
> This is not what a checkpoint file is for. A checkpoint file is created so that you can do time based recoveries using th edatabsse journals. 
> 
> What you want is a static backup created with either unloaddb or copydb. Those are designed for exactly this sort of task. 
> 
> Marty
> -----Original Message----- 
> From: Rich Ford <richf... at gmail.com> 
> Sent: 25 January 2022 14:02 
> To: info-... at lists.planetingres.org 
> Subject: [Info-ingres] Recover Database 
> 
> Is it possible to save a checkpoint file in a backup directory then destroy the database, create the database and then use this checkpoint file to recover the database the state prior to the destroy? 
> 
> Rich
> _______________________________________________ 
> Info-ingres mailing list 
> Info-... at lists.planetingres.org 
> https://lists.planetingres.org/mailman/listinfo/info-ingres

Thanks for the quick reply.

Rich