Skip site navigation (1) Skip section navigation (2)

PostgreSQL Upgrade recommendations

From: "Andrew Parkyns" <andrew(dot)parkyns(at)microgen(dot)co(dot)uk>
To: <pgsql-ports(at)postgresql(dot)org>
Subject: PostgreSQL Upgrade recommendations
Date: 2004-08-09 11:03:57
Message-ID: auto-000004324498@microgen.co.uk (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-ports
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(dot)support(at)microgen(dot)co(dot)uk

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

Responses

pgsql-ports by date

Next:From: Merlin MoncureDate: 2004-08-09 14:04:52
Subject: Re: PostgreSQL Upgrade recommendations
Previous:From: Kris JurkaDate: 2004-08-06 07:14:39
Subject: Re: PROBLEMS!!!

pgsql-admin by date

Next:From: Robert TreatDate: 2004-08-09 14:38:23
Subject: Re: [PORTS] PostgreSQL Upgrade recommendations
Previous:From: Andrew J DelamareDate: 2004-08-09 10:12:53
Subject: Adding multiple instances to 7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group