pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Crawford <scrawford@pinpointresearch.com>
To: Chris Hoover <revoohc@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org Admin <pgsql-admin@postgresql.org>
Subject: Re: Upgrading from 7.2.1 to 8.x
Date: Thu, 01 Nov 2007 09:49:54 -0700
Message-ID: <472A03B2.3020206@pinpointresearch.com> (raw)
In-Reply-To: <dcc563d10710311258j7c917ee0s6fa03ec447d22996@mail.gmail.com>
References: <1d219a6f0710311028s745446aay7dd59c1982af7b03@mail.gmail.com>
	<dcc563d10710311258j7c917ee0s6fa03ec447d22996@mail.gmail.com>

>> I have been pushing for 3 years to upgrade this database, and with some
>> upcoming projects, I am going to do another push with management to upgrade
>> this database.
> 
> Push hard.  They'll thank you later.

No they won't. They have been running this way fine for years - if they
haven't crashed so far, why would they stop driving home sans-seatbelts
after a knocking back a few at the nightly bar bash now? But introduce a
big change and all problems and frustrations involved in the change will
reflect on you.

It takes some upfront work, but I would write up a proposal. First,
scour the release notes and document all the security and data-eating
bugs that have been fixed. Mention that support for 7.2 long-since ended.

Second, identify features that have been added that would be of use in
your business or which would make development of your upcoming projects
easier. Include features that make maintenance and operation easier as
well (stuff like autovacuum).

Third, point out that the substantial performance improvements through
the versions will allow you to use less expensive hardware than would
otherwise be required.

Finally, be upfront about the fact that upgrading will require effort
and could introduce some initial glitches. But point out that long-term
you will be much better off tweaking your app to run on the latest
version of PG and developing from there than digging your hole deeper by
writing even more code tied to the old, old version.

Then it's their decision. If they say no, you have a document you can
refer to when things go bad (but with luck you will have found a new job
by then). If they say yes, you will have the same document pointing out
that they should expect some initial difficulties in the process.

Good luck.

Cheers,
Steve



view thread (5+ messages)

Message-ID: <472A03B2.3020206@pinpointresearch.com>
Permalink:  ../472A03B2.3020206@pinpointresearch.com/
Also on:    postgresql.org/message-id/472A03B2.3020206@pinpointresearch.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: scrawford@pinpointresearch.com, revoohc@gmail.com, scott.marlowe@gmail.com
  Subject: Re: Upgrading from 7.2.1 to 8.x
  In-Reply-To: <472A03B2.3020206@pinpointresearch.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