Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

Statistics are no substitute for judgement. -- Henry Clay

devel / comp.databases.ingres / Re: create new database from checkpoint

SubjectAuthor
* create new database from checkpointRich Ford
+* Re: create new database from checkpointRoy Hann
|`* Re: create new database from checkpointRich Ford
| `* Re: create new database from checkpointRoy Hann
|  `- Re: create new database from checkpointRich Ford
`- Re: [Info-ingres] create new database from checkpointMartin Bowes

1
create new database from checkpoint

<ab068e78-ffa6-440f-8877-9fea88b7b898n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=151&group=comp.databases.ingres#151

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:620a:4446:: with SMTP id w6mr20198044qkp.631.1638571676892;
Fri, 03 Dec 2021 14:47:56 -0800 (PST)
X-Received: by 2002:a9d:f4a:: with SMTP id 68mr18979758ott.327.1638571676624;
Fri, 03 Dec 2021 14:47:56 -0800 (PST)
Path: i2pn2.org!i2pn.org!aioe.org!news.mixmin.net!newsreader4.netcologne.de!news.netcologne.de!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Fri, 3 Dec 2021 14:47:56 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d500:6b60:c184:efd7:2fe9:3757;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d500:6b60:c184:efd7:2fe9:3757
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ab068e78-ffa6-440f-8877-9fea88b7b898n@googlegroups.com>
Subject: create new database from checkpoint
From: richford990@gmail.com (Rich Ford)
Injection-Date: Fri, 03 Dec 2021 22:47:56 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1191
 by: Rich Ford - Fri, 3 Dec 2021 22:47 UTC

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

Re: create new database from checkpoint

<soeclh$4v0$1@gioia.aioe.org>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=152&group=comp.databases.ingres#152

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specially@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: create new database from checkpoint
Date: Sat, 4 Dec 2021 00:27:29 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <soeclh$4v0$1@gioia.aioe.org>
References: <ab068e78-ffa6-440f-8877-9fea88b7b898n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="5088"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2
 by: Roy Hann - Sat, 4 Dec 2021 00:27 UTC

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

Re: create new database from checkpoint

<174edb09-211b-4eeb-b10e-e485b0629e06n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=154&group=comp.databases.ingres#154

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:620a:4ef:: with SMTP id b15mr30432409qkh.662.1638745702669;
Sun, 05 Dec 2021 15:08:22 -0800 (PST)
X-Received: by 2002:a9d:64d4:: with SMTP id n20mr25989686otl.328.1638745702390;
Sun, 05 Dec 2021 15:08:22 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Sun, 5 Dec 2021 15:08:22 -0800 (PST)
In-Reply-To: <soeclh$4v0$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d500:6b60:4484:7fad:6787:ebd6;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d500:6b60:4484:7fad:6787:ebd6
References: <ab068e78-ffa6-440f-8877-9fea88b7b898n@googlegroups.com> <soeclh$4v0$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <174edb09-211b-4eeb-b10e-e485b0629e06n@googlegroups.com>
Subject: Re: create new database from checkpoint
From: richford990@gmail.com (Rich Ford)
Injection-Date: Sun, 05 Dec 2021 23:08:22 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 12
 by: Rich Ford - Sun, 5 Dec 2021 23:08 UTC

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.

Re: [Info-ingres] create new database from checkpoint

<mailman.109.1638779441.1681.info-ingres@lists.planetingres.org>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=155&group=comp.databases.ingres#155

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Mon, 06 Dec 2021 02:32:03 -0600
Return-Path: <martin.bowes@ndph.ox.ac.uk>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: martin.bowes@ndph.ox.ac.uk (Martin Bowes)
To: Rich Ford <richford990@gmail.com>, "info-ingres@lists.planetingres.org"
<info-ingres@lists.planetingres.org>
Date: Mon, 6 Dec 2021 08:30:39 +0000
References: <ab068e78-ffa6-440f-8877-9fea88b7b898n@googlegroups.com>
In-Reply-To: <ab068e78-ffa6-440f-8877-9fea88b7b898n@googlegroups.com>
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-WatchGuard-AntiVirus: part scanned. clean action=allow
Subject: Re: [Info-ingres] create new database from checkpoint
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.109.1638779441.1681.info-ingres@lists.planetingres.org>
Lines: 36
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-ftsPo98t2Rcjon4mCLDpW/YJ4hgP0ymcucA/TZUY6I6hshbPL2Zh1cNjfsARD+rfsO3bsR/aD1IH7TD!zh9fbAZrvdRpQ+n6RZ8B4nHjF0xkp8UmKa8dAxNjeOWYoO5ngAyFZ8kAlIRGwvWNWi2TYYEti8ek!GXwgp1/5wZIuMHMYkUgW8Cw=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 3431
 by: Martin Bowes - Mon, 6 Dec 2021 08:30 UTC

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

Re: create new database from checkpoint

<sol610$roa$1@gioia.aioe.org>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=157&group=comp.databases.ingres#157

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specially@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: create new database from checkpoint
Date: Mon, 6 Dec 2021 14:17:04 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <sol610$roa$1@gioia.aioe.org>
References: <ab068e78-ffa6-440f-8877-9fea88b7b898n@googlegroups.com> <soeclh$4v0$1@gioia.aioe.org> <174edb09-211b-4eeb-b10e-e485b0629e06n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="28426"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2
 by: Roy Hann - Mon, 6 Dec 2021 14:17 UTC

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

Re: create new database from checkpoint

<39a922be-ac23-4b18-8f8f-6c252a221815n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=158&group=comp.databases.ingres#158

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:620a:28d0:: with SMTP id l16mr33427685qkp.500.1638802080744;
Mon, 06 Dec 2021 06:48:00 -0800 (PST)
X-Received: by 2002:a05:6808:1a90:: with SMTP id bm16mr24873109oib.133.1638802080465;
Mon, 06 Dec 2021 06:48:00 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Mon, 6 Dec 2021 06:48:00 -0800 (PST)
In-Reply-To: <sol610$roa$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d500:6b60:c9e0:859:4672:3367;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d500:6b60:c9e0:859:4672:3367
References: <ab068e78-ffa6-440f-8877-9fea88b7b898n@googlegroups.com>
<soeclh$4v0$1@gioia.aioe.org> <174edb09-211b-4eeb-b10e-e485b0629e06n@googlegroups.com>
<sol610$roa$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <39a922be-ac23-4b18-8f8f-6c252a221815n@googlegroups.com>
Subject: Re: create new database from checkpoint
From: richford990@gmail.com (Rich Ford)
Injection-Date: Mon, 06 Dec 2021 14:48:00 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 26
 by: Rich Ford - Mon, 6 Dec 2021 14:48 UTC

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

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor