From Newsgroup: comp.databases.ingres

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.

Thanks,
Rich
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

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
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

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.
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

Hi Rich,
Yes, but with some caveats.
The two hosts must be kept in synch with both OS and Ingres version levels. Furthermore they must have the same directory structure for the Ingres installations. That is II_SYSTEM, II_DATABASE, II_JOURNAL etc must be the same.
Do you need any instruction in how to proceed from here to effect the recovery? If you intend to allow multiple Ingres installations to use a single recovery host then I suggest you create each of the primary installations with a distinct installation identifier and different paths for II_SYSTEM etc. Trust me that helps significantly and it's far better to set that up initially than attempt to retrofit it later.
Marty
-----Original Message-----
From: Rich Ford <richford990@gmail.com>
Sent: 03 December 2021 22:48
To: info-ingres@lists.planetingres.org
Subject: [Info-ingres] create new database from checkpoint
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.
Thanks,
Rich
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

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

--- Synchronet 3.21b-Linux NewsLink 1.2

From Newsgroup: comp.databases.ingres

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
--- Synchronet 3.21b-Linux NewsLink 1.2