[Info-ingres] create new database from checkpoint

Roy Hann specially at processed.almost.meat
Mon Dec 6 14:17:04 UTC 2021


Rich Ford wrote:

> On Friday, 3 December 2021 at 16:27:31 UTC-8, Roy Hann wrote:
>> Rich Ford wrote: 
>> 
>> > Is it possible to use a checkpoint from one Linux server and use this to create the database on another Linux server? 
>> > Both are 64 bit SUSE.
>> Short answer, yes. We do it all the time for UAT, and not just on 
>> Linux. 
>> 
>> What are you planning? 
>> 
>> Roy
>
> We are setting up a new Dev/QA environment and want to load prod data here.

Have you ruled out using relocatedb to clone the database? It can be
more flexible than restoring from a checkpoint (provided your database
is not colossal).

Roy



More information about the Info-ingres mailing list