Re: [ADMIN] postgres 6.2 vacuum

From: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [ADMIN] postgres 6.2 vacuum
Date: 2003-09-26 00:18:48
Message-ID: Pine.LNX.4.21.0309252251330.5789-100000@tiger.tigrasoft.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers


No, I got this job 2 months ago, I don`t know who managed it before, and I
don`t know why didn`t he upgrade. Until this week I didn`t have the chance
to upgrade.
But it runs now on 7.3.4.

On Thu, 25 Sep 2003, Richard Huxton wrote:

> On Thursday 25 September 2003 07:36, Hornyak Laszlo wrote:
> > I think it is not that simple. How should I explain the company leaders
> > why I must stop the system. It may risk their bussiness success too. I can
> > tell them that the new db is more stable, but until the old one does the
> > job, it is still acceptable for them (it served the system for 5-6 years
> > or so).
>
> Here, I agree with you Hornyak - you've got 5+ years real-world experience
> with this version and it does what you want (mostly). I'm half tempted to
> downgrade myself ;-)

<OFF>
If you think you can do it better, the job is yours.
</OFF>

Laszlo Hornyak

>
> By the way - are you saying the your system has been running *without
> interruption* for 5 years?
>
> Having said that, when (and it's when, not if) you upgrade, you'll be looking
> at some major changes in PG, so it's probably a good idea to test 7.3.4 and
> see what changes are necessary now, before you need to. Short-term, could you
> stop the system long enough to pg_dump it and restore? Again, test the
> process first.
>
> > Once it crashes, it is a good reason to do the move.
>
> And just *before* it crashes is the best time.
>
> --
> Richard Huxton
> Archonet Ltd
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-09-26 00:27:55 Re: invalid page header
Previous Message Donald Fraser 2003-09-25 23:52:16 Re: Case Insensitive Test

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Yarra 2003-09-26 00:20:06 Re: [pgsql-www] NuSphere and PostgreSQL for windows
Previous Message Tom Lane 2003-09-26 00:04:08 Re: pgsql-server/src/backend catalog/index.c comma ...