1. Forum
  2. Usenet
  3. COMP.DATABASES.INGRES

  • create new database from checkpoint

    From Rich Ford@21:1/5 to All on Fri Dec 3 14:47:56 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to Rich Ford on Sat Dec 4 00:27:29 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rich Ford@21:1/5 to Roy Hann on Sun Dec 5 15:08:22 2021
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to Rich Ford on Mon Dec 6 08:30:39 2021
    To: info-ingres@lists.planetingres.org (info-ingres@lists.planetingres.org)

    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to Rich Ford on Mon Dec 6 14:17:04 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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rich Ford@21:1/5 to Roy Hann on Mon Dec 6 06:48:00 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)