[Info-ingres] Recover Database

[Martin Bowes]

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 <richford990 at gmail.com> 
Sent: 25 January 2022 14:02
To: info-ingres 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-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres