Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

One man's constant is another man's variable. -- A. J. Perlis

devel / comp.databases.ingres / Re: [Info-ingres] Refresh dev databases

SubjectAuthor
* Refresh dev databasesRich Ford
`- Re: [Info-ingres] Refresh dev databasesPaul White

1
Refresh dev databases

<65701d3b-9834-4208-b09a-10c7ab410abdn@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:622a:189:: with SMTP id s9mr8231557qtw.556.1642524383911;
Tue, 18 Jan 2022 08:46:23 -0800 (PST)
X-Received: by 2002:a4a:d116:: with SMTP id k22mr15179513oor.80.1642524383623;
Tue, 18 Jan 2022 08:46:23 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!newsreader4.netcologne.de!news.netcologne.de!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!peer03.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: Tue, 18 Jan 2022 08:46:23 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d500:6b60:6552:5085:5b4c:89aa;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d500:6b60:6552:5085:5b4c:89aa
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <65701d3b-9834-4208-b09a-10c7ab410abdn@googlegroups.com>
Subject: Refresh dev databases
From: richford...@gmail.com (Rich Ford)
Injection-Date: Tue, 18 Jan 2022 16:46:23 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1309
 by: Rich Ford - Tue, 18 Jan 2022 16:46 UTC

I've been looking at using clonedb to do a refresh of some dev databases from production. I've only used unloaddb before but checking out clonedb.
One issue that concerns me is the fact that users can't be online which is a major drawback.

Has anyone had success using clonedb?

Rich

Re: [Info-ingres] Refresh dev databases

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

  copy mid

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

  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!buffer1.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Tue, 18 Jan 2022 18:06:03 -0600
Return-Path: <shift7solutions@gmail.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112;
h=message-id:date:mime-version:user-agent:reply-to:subject
:content-language:to:references:cc:from:organization:in-reply-to
:content-transfer-encoding;
bh=FWJtBNqG1HEpHtO/7j05cz2vI2z6V1u+X/hrUXOkP0Y=;
b=Pu1u2i61SuF4L7n+2BB7yOuy9sloQemvkCRqIpYeGWg/TC/44oQx49MYJETBHUx06U
PS6L+RWBhjlCUBC8N6HuoGrgbLbwJ/aGgPj6W3vxzZlxQfU6I399auO5/bOB/8Rq1lin
Z2Nw8rcvLHWqpBpcisUXAk6yERmNhhXeFeF0wxAplGcDxvit82TO46/XZaLFjbxrtztu
/AhRyFZMFRHNhqBBkm0OICTd67NqBP2xdJo/UvDkGsF3vS4m6LnKF/t8TfL4fyge1dr2
W9utCw9YDt2GA4SXlAgzl23XSD9FijjpbXHhL2As5VWqq1zc6/VgTteaOuRnUQl7UwqH
W9uQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20210112;
h=x-gm-message-state:message-id:date:mime-version:user-agent:reply-to
:subject:content-language:to:references:cc:from:organization
:in-reply-to:content-transfer-encoding;
bh=FWJtBNqG1HEpHtO/7j05cz2vI2z6V1u+X/hrUXOkP0Y=;
b=IW+EWF3+oOjAqOKz7af0TbZPcnulBx7iEA5Vi+PwvRuOLYlNMh95RA1oQ/FUpKpzRL
CKfy1eDWreFBE2Da91L5o7qTsGGtf5mY2S8qRj8V8LSW2ScvXk6TgGHskF7s0cSD3uH7
VOWsUBcJkYqkqVkB4/fNAUY4fpl1cMsMq2Xh6hHc6sZ3aKPTYmyHYpIEkPYky4ejpBO5
Im4mYl+LH0+JOv5nf5aizudvcFd1nHdyOif5DXmbD2vL6Yyp4Glt9czwsuMJamMHzPTx
qI1ym6rQTFdVFK3tRw2WbAytqTE3mqbjK3/uf9zSr2vmQr3P7R3Uq9KX+iBIGadvz3oX
n92A==
X-Gm-Message-State: AOAM5331AiYGu8zVyQTjkI3NC1pOkmJoNK5XEZgXpNghmpczPQmCCGOY
Y/eqkTtpMc4TWjxQWOPDEaw3uVhGgOROtw==
X-Google-Smtp-Source: ABdhPJxB8KQu0ovRoL+Lvz1f3aIzDax8D+gvKcDFRQua8+cwork3lSR5zUx7A6zZcB34TsA7Zj/9lw==
X-Received: by 2002:a17:90a:748e:: with SMTP id
p14mr1143933pjk.231.1642550650106;
Tue, 18 Jan 2022 16:04:10 -0800 (PST)
Date: Wed, 19 Jan 2022 10:04:03 +1000
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.5.0
Reply-To: shift7solutions@gmail.com
Content-Language: en-US
To: info-ingres <info-ingres@lists.planetingres.org>
References: <65701d3b-9834-4208-b09a-10c7ab410abdn@googlegroups.com>
From: shift7so...@gmail.com (Paul White)
Organization: Shift Seven Solutions
In-Reply-To: <65701d3b-9834-4208-b09a-10c7ab410abdn@googlegroups.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Cc: Rich Ford <richford990@gmail.com>
Subject: Re: [Info-ingres] Refresh dev databases
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.123.1642550654.1681.info-ingres@lists.planetingres.org>
Lines: 40
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-z01Sv0pS5sEVeGI6A2kdLFVUXZKmJcZNIrmIi5JlK9W7Jp0ezJHOPWmkXSz2OgH97y4tB9v095moKjq!PPJXX2WacsNsVMVVf6m73dP+gMLVz8rwtYvywWcTMCDQiYgqqCOGSONqQXHStoighkheaqsnvATy!n0u9H95dHNP4+GOOpYf3yXk=
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: 5368
 by: Paul White - Wed, 19 Jan 2022 00:04 UTC

Hi Rich,

At my large sites, I use "log shipping" to replicate production
databases to a DR standby machine then use copydb/unloaddb  from that
location when I need.  One of the benefits of this arrangement is to be
able to rollforward the DR database to a point in time for analysis and
to assist reproducing transient problems.

clonedb and relocatedb cannot be used when users are connected.
clonedb/relocatedb can be used on a replicated database after the final
incremental journal is applied with:

rollforwarddb -c +j -incremental -rollback dbname
or
rollforwarddb -c +j -incremental_finish -rollback dbname

For more info see:
https://communities.actian.com/s/article/Incremental-Rollforwarddb

I can confirm log shipping replication works very well for non x100
databases on both Windows and Unix/Linux.  Sorry I don't have any
experience replicating x100.

Paul White

&

On 19/01/2022 2:46 am, Rich Ford wrote:
> I've been looking at using clonedb to do a refresh of some dev databases from production. I've only used unloaddb before but checking out clonedb.
> One issue that concerns me is the fact that users can't be online which is a major drawback.
>
> Has anyone had success using clonedb?
>
> Rich
> _______________________________________________
> Info-ingres mailing list
> Info-ingres@lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor