Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

God doesn't play dice. -- Albert Einstein


devel / comp.databases.ingres / Re: rollforwarddb

SubjectAuthor
* rollforwarddbRich Ford
`- Re: rollforwarddbRoy Hann

1
rollforwarddb

<a0870810-fbfb-42db-a23d-0b53cc24ab40n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:6214:1948:b0:456:3aac:af92 with SMTP id q8-20020a056214194800b004563aacaf92mr18172009qvk.24.1651247842222;
Fri, 29 Apr 2022 08:57:22 -0700 (PDT)
X-Received: by 2002:a05:6870:d78d:b0:d4:4b29:7ccc with SMTP id
bd13-20020a056870d78d00b000d44b297cccmr1638205oab.69.1651247841953; Fri, 29
Apr 2022 08:57:21 -0700 (PDT)
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: Fri, 29 Apr 2022 08:57:21 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d502:9200:246e:cc61:28bf:17b4;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d502:9200:246e:cc61:28bf:17b4
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a0870810-fbfb-42db-a23d-0b53cc24ab40n@googlegroups.com>
Subject: rollforwarddb
From: richford990@gmail.com (Rich Ford)
Injection-Date: Fri, 29 Apr 2022 15:57:22 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 8
 by: Rich Ford - Fri, 29 Apr 2022 15:57 UTC

We are trying to restore database on 11.1 to a couple days back running the following:

rollforwarddb db1 -e27-APR-2022:01:02:00

This seems to succeed but the databases is not set to this timestamp.

Are there other steps involved?

Rich

Re: rollforwarddb

<t4iv2f$84m$1@gioia.aioe.org>

  copy mid

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

  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: rollforwarddb
Date: Sat, 30 Apr 2022 09:21:19 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <t4iv2f$84m$1@gioia.aioe.org>
References: <a0870810-fbfb-42db-a23d-0b53cc24ab40n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="8342"; 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, 30 Apr 2022 09:21 UTC

Rich Ford wrote:

> We are trying to restore database on 11.1 to a couple days back running the following:
>
> rollforwarddb db1 -e27-APR-2022:01:02:00
>
> This seems to succeed but the databases is not set to this timestamp.
>
> Are there other steps involved?

Was it journalled?

Run infodb on it and look for "The Database is not Journaled".

Roy

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor