Thread: PostgreSQL Upgrade recommendations

PostgreSQL Upgrade recommendations

From
"Andrew Parkyns"
Date:

Hi,

 

I’ve just joined this morning and I wonder if anyone could help? I’d like some opinions / war stories / suggestions/ recommendations whatever on PostgreSQL upgrades.

 

We have a PostgreSQL 7.2.1 server on Linux RHL 9 Enterprise / Intel port.

 

I am quite new to Postgres (my day job is an Oracle DBA) but I am experienced in handling critical upgrades etc. on other platforms.

 

Feedback from the Forum, please, on:

 

  • I want an up-to-date upgrade version, not too new and unstable. Which one? 7.4.x? Wait for 7.5? I don’t want to do this too often so I would like to space major upgrade intervals by at least 12 months if possible.
  • Any really pressing reasons to move off 7.2.x ? Nasty bugs not patches until later versions?
  • 3rd party software Incompatibility issues?
  • Reasons of performance / functionality?

 

I would be most grateful to receive feedback from anyone out there. Very much looking forward to your replies

 

 

Andrew Parkyns

Microgen plc.,

Welwyn Garden City

UK


________________________________________________________________________
This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.

DISCLAIMER

This email and any attachments are confidential and may also be
privileged.

If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.

In the event of any technical difficulty with this email, please
contact the sender or it.support@microgen.co.uk

Microgen Information Management Solutions
http://www.microgen.co.uk

Re: PostgreSQL Upgrade recommendations

From
"Merlin Moncure"
Date:
We have a PostgreSQL 7.2.1 server on Linux RHL 9 Enterprise / Intel
port.
7.4.x? Wait for 7.5? I don't want to do this too often so I would like
to space major upgrade intervals by at least 12 months if possible.

7.5 has a lot of new stuff in it.  If that new stuff applies to you then
go for it, otherwise might be smart to wait for 8.1 (7.5 == 8.0).  If
you don't care about win32, the next biggest thing is probably
savepoints.  If you are the conservative type, I would not target an 8.0
deployment earlier than Jan 1. 2005.

* Any really pressing reasons to move off 7.2.x ? Nasty bugs not patches
until later versions?

Yes, 7.4 got a lot of improvements to the query optimizer, a major
protocol overhaul, and takes better care of your data in crash
scenarios, not to mention all the 7.3 stuff.

* 3rd party software Incompatibility issues?

Possibly, in a few minor cases the sql commands are not backwards
compatible.  However, the protocols are.  If you have a lot of
integration, there might be some problems.

* Reasons of performance / functionality?

Yes, postgres just keeps getting better and better.  Each major version
brings a huge amount of functionality and power.

Merlin

Re: PostgreSQL Upgrade recommendations

From
Robert Treat
Date:
moving to pgsql-admin which is much more appropriate for this type of post

On Monday 09 August 2004 07:03, Andrew Parkyns wrote:
> Hi,
> I've just joined this morning and I wonder if anyone could help? I'd like
> some opinions / war stories / suggestions/ recommendations whatever on
> PostgreSQL upgrades.
>
> We have a PostgreSQL 7.2.1 server on Linux RHL 9 Enterprise / Intel port.
>
> I am quite new to Postgres (my day job is an Oracle DBA) but I am
> experienced in handling critical upgrades etc. on other platforms.
>
> Feedback from the Forum, please, on:
>
> *    I want an up-to-date upgrade version, not too new and unstable.
> Which one? 7.4.x? Wait for 7.5? I don't want to do this too often so I
> would like to space major upgrade intervals by at least 12 months if
> possible.

Well, 7.5 is really 8.0, and probably wont be out for 2-3 more months, so if
you can't wait that long the decision is made for you.  PostgreSQL has been
doing major releases about every 12 months for the last couple years, so
factor that into your decision as well.  You might also want to check out the
developer copy of the 8.0 release notes (in the docs at
developer.postgresql.org) to see if there are any features you might want to
make immediate use of.

> *    Any really pressing reasons to move off 7.2.x ? Nasty bugs not
> patches until later versions?

I am sure there are some, but nothing that will cause total data loss.  Other
reasons might include new features, better performance, and smaller bug
fixes.

> *    3rd party software Incompatibility issues?

You might find some, though given that 7.2 is like 2 years old most software
should have had time to do some type of update by now.  For instance, a
client I did an upgrade for found that 7.4 broke thier version of double
choco latte (time management software) but there were updates to that
software that had never been applied either so in the end it all worked out.

> *    Reasons of performance / functionality?
>

7.3 performed better than 7.2,  and 7.4 performed better than 7.3, and it
looks like 8.0 will out perform 7.4.  And every new versions adds new
functionality, so yes.

--
Robert Treat
Build A Better Lamp :: Linux Apache {middleware} PostgreSQL

Re: PostgreSQL Upgrade recommendations

From
Tom Lane
Date:
"Andrew Parkyns" <andrew.parkyns@microgen.co.uk> writes:
> We have a PostgreSQL 7.2.1 server on Linux RHL 9 Enterprise / Intel port.

> *    I want an up-to-date upgrade version, not too new and unstable.
> Which one? 7.4.x? Wait for 7.5? I don't want to do this too often so I would
> like to space major upgrade intervals by at least 12 months if possible.

7.4.latest would be your best bet.  Given the degree of conservatism you
are expressing, you will not want to move onto the 8.0.* (nee 7.5)
series for about a year anyway.

> *    Any really pressing reasons to move off 7.2.x ? Nasty bugs not
> patches until later versions?

There are *really* good reasons not to be running 7.2.1 --- see the
release notes for the later 7.2.* releases.  You should most certainly
update to 7.2.4 (or whatever the last of that series was) ASAP.  Moving
to 7.3.* or 7.4.* would entail a dump/reload as well as posing some
possible compatibility risks, so that's a bigger jump and you need to
think harder about if it's worth it to you.

In general, whatever release series you're using, you should be at the
latest release in the series.  We only do bug fixes in minor releases,
and usually only bother for fairly serious bugs.

> *    Reasons of performance / functionality?

Generally the performance and functionality both get better with every
release.  But it's impossible to say at this level of detail whether
7.3 or 7.4 will have anything especially attractive for your particular
situation.

            regards, tom lane

Re: PostgreSQL Upgrade recommendations

From
"Merlin Moncure"
Date:
> Merlin,
> I was intrigued by the equation of versions 7.5 and 8.0, a leaf out of
> Oracle's release procedure, perhaps?

Not really sure.  During the development cycle the upcoming version was
referred to as 7.5.  Once it became clear most/all of the big features
were going to make it, there was an informal vote to re-dub the version
8.0.

> Also interesting to hear about proposed new functionality on 8.1 and
above

That was a typo in my part...meant 8.0.1, which was one bug fix release
after the major feature release.

> is there any more technical information available on this?
>
> Thanks once again for your help

8.1 will probably see some of the features didn't quite make it in to
8.0...autovacuum comes to mind.  For good info on 8.0 issues, you need
to be following hackers mailing list for the time being, although now
that the beta is stamped there will be more information.  You might also
want to check out the development docs on the main page.

Merlin

Re: PostgreSQL Upgrade recommendations

From
"Andrew Parkyns"
Date:
Thanks also to Tom and Robert - excellent advice thanks very much.

I will now do as suggested & check out the version release notes - for 7.4
latest patch, and plan for upgrade to this version for the immediate future.

We will probably be most interested in looking at 8.1 + as the next port so
will be looking forward to information on that in the future.

One last question [greedy, I know]. Does the Postgres release information
contain OS compatibility matrices? [e.g. OS patch requirements etc.]

Very many thanks I certainly have enough to head onwards and upwards.

Andrew.

-----Original Message-----
From: Robert Treat [mailto:xzilla@users.sourceforge.net]
Sent: 09 August 2004 15:38
To: Andrew Parkyns
Cc: pgsql-ports@postgresql.org; pgsql-admin@postgresql.org
Subject: Re: [PORTS] PostgreSQL Upgrade recommendations

moving to pgsql-admin which is much more appropriate for this type of post

On Monday 09 August 2004 07:03, Andrew Parkyns wrote:
> Hi,
> I've just joined this morning and I wonder if anyone could help? I'd like
> some opinions / war stories / suggestions/ recommendations whatever on
> PostgreSQL upgrades.
>
> We have a PostgreSQL 7.2.1 server on Linux RHL 9 Enterprise / Intel port.
>
> I am quite new to Postgres (my day job is an Oracle DBA) but I am
> experienced in handling critical upgrades etc. on other platforms.
>
> Feedback from the Forum, please, on:
>
> *    I want an up-to-date upgrade version, not too new and unstable.
> Which one? 7.4.x? Wait for 7.5? I don't want to do this too often so I
> would like to space major upgrade intervals by at least 12 months if
> possible.

Well, 7.5 is really 8.0, and probably wont be out for 2-3 more months, so if

you can't wait that long the decision is made for you.  PostgreSQL has been
doing major releases about every 12 months for the last couple years, so
factor that into your decision as well.  You might also want to check out
the
developer copy of the 8.0 release notes (in the docs at
developer.postgresql.org) to see if there are any features you might want to

make immediate use of.

> *    Any really pressing reasons to move off 7.2.x ? Nasty bugs not
> patches until later versions?

I am sure there are some, but nothing that will cause total data loss.
Other
reasons might include new features, better performance, and smaller bug
fixes.

> *    3rd party software Incompatibility issues?

You might find some, though given that 7.2 is like 2 years old most software

should have had time to do some type of update by now.  For instance, a
client I did an upgrade for found that 7.4 broke thier version of double
choco latte (time management software) but there were updates to that
software that had never been applied either so in the end it all worked out.


> *    Reasons of performance / functionality?
>

7.3 performed better than 7.2,  and 7.4 performed better than 7.3, and it
looks like 8.0 will out perform 7.4.  And every new versions adds new
functionality, so yes.

--
Robert Treat
Build A Better Lamp :: Linux Apache {middleware} PostgreSQL

________________________________________________________________________
This email was checked by MessageLabs SkyScan before entering Microgen.


________________________________________________________________________
This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.

DISCLAIMER

This email and any attachments are confidential and may also be
privileged.

If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.

In the event of any technical difficulty with this email, please
contact the sender or it.support@microgen.co.uk

Microgen Information Management Solutions
http://www.microgen.co.uk