Subject | Re: [firebird-support] High CPU use after restore |
---|---|
Author | Jardar Maatje |
Post date | 2015-10-29T08:55:20Z |
jardar
On Thu, Oct 29, 2015 at 9:52 AM, Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> wrote:On Thu, 29 Oct 2015 07:43:29 +0100, "Jardar Maatje
jardar.maatje@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
> Hi again,
>
> Sounds like a reasonable cause for the problem. So now is my question,
what
> is the best way to upgrade.
> My current setup is as follows:
> I have two databases, one for raw data (RAW), and the second one for
> decoded data (MAIN). I need to keep the RAW db with as high availability
as
> possible (or we will loose incoming data). For the MAIN db I have more
> slack regarding downtime (weekends/nights). They both have ODS version
> 11.2.
>
> The best would be if I could upgrade to the latest version (2.5.4) of
the
> server db without the need to do backup/restore as this takes a lot of
> time.
You will need to backup and restore or at least rebuild the indexes, see
the release notes for 2.5.3:
http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes254.html#notes-253
Mark
--Jardar MaatjeNortek Data Services ASC.J. Hambros Plass 2C0164 Oslotlf: +47 95184034