pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Medi Montaseri <montaseri@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: ROI on 7.2 to 8.2
Date: Tue, 21 Aug 2007 12:29:46 -0500
Message-ID: <dcc563d10708211029h1fdcce83g1c3cd9eb1cf17066@mail.gmail.com> (raw)
In-Reply-To: <8078a1730708211016u7f825121s9abc8e015aab53a0@mail.gmail.com>
References: <8078a1730708211016u7f825121s9abc8e015aab53a0@mail.gmail.com>

On 8/21/07, Medi Montaseri <montaseri@gmail.com> wrote:
> Hi,
>
> I have finally convinced my manager to "consider" the idea of migrating from
> 7.2 to 8.2. Obviously he needs an ROI (Return Of Investment) analysis (in a
> technical sense).
>
> So, I am wondering if anyone has worked on a similar project where you had
> to go thru the release notes and bug fixes to compile such a motivational
> speech and willing to share.

This one's really pretty simple.

1: 7.2 is no longer supported by the community.  any issues, you're
pretty much on your own.
2: 7.2 has a problem with transaction ID wraparound that cannot be
fixed.  You have to dump and reload your data every so often or you
will lose data
3: I believe, but I'm not entirely sure, that there are other known
breakages in 7.2 that will eat your data eventually.  Scour the list
for references to such things by Tom Lane.



view thread (6+ messages)  latest in thread

Message-ID: <dcc563d10708211029h1fdcce83g1c3cd9eb1cf17066@mail.gmail.com>
Permalink:  ../dcc563d10708211029h1fdcce83g1c3cd9eb1cf17066@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10708211029h1fdcce83g1c3cd9eb1cf17066@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, montaseri@gmail.com
  Subject: Re: ROI on 7.2 to 8.2
  In-Reply-To: <dcc563d10708211029h1fdcce83g1c3cd9eb1cf17066@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox