[Info-ingres] create new database from checkpoint

[Rich Ford]

On Monday, 6 December 2021 at 06:17:07 UTC-8, Roy Hann wrote:
> 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

Our databases are not very big.
Will try relocatedb. Going forward we'll be doing weekly refreshes from prod into this environment.
Is relocatedb also a good method of doing refreshes?

Rich