X-Original-To: pgsql-ports-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D5CED14B27F6 for ; Mon, 9 Aug 2004 08:02:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69716-03 for ; Mon, 9 Aug 2004 11:02:36 +0000 (GMT) Received: from mail25.messagelabs.com (mail25.messagelabs.com [193.109.254.115]) by svr1.postgresql.org (Postfix) with SMTP id 3C78E14B287F for ; Mon, 9 Aug 2004 08:02:32 -0300 (ADT) X-VirusChecked: Checked X-Env-Sender: andrew.parkyns@microgen.co.uk X-Msg-Ref: server-10.tower-25.messagelabs.com!1092049351!8540349 X-StarScan-Version: 5.2.10; banners=microgen.co.uk,-,- X-Originating-IP: [62.172.191.138] Received: (qmail 29671 invoked from network); 9 Aug 2004 11:02:31 -0000 Received: from unknown (HELO mailfilter.microgen.co.uk) (62.172.191.138) by server-10.tower-25.messagelabs.com with SMTP; 9 Aug 2004 11:02:31 -0000 Received: from microgen.co.uk (wgcmail [62.172.191.173]) by mailfilter.microgen.co.uk (8.11.2/8.8.7) with ESMTP id i79B2W914727 for ; Mon, 9 Aug 2004 12:02:32 +0100 Received: from [194.100.101.89] (account andrew.parkyns HELO MIC03671) by microgen.co.uk (CommuniGate Pro SMTP 4.0.6) with ESMTP id 4324498 for pgsql-ports@postgresql.org; Mon, 09 Aug 2004 12:03:39 +0100 From: "Andrew Parkyns" To: Subject: PostgreSQL Upgrade recommendations Date: Mon, 9 Aug 2004 12:03:57 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C47E08.F3526D00" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcR+AJE1ffBMkDsgSPuXDGA+tb+bEw== Message-ID: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200408/4 X-Sequence-Number: 1830 This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C47E08.F3526D00 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0016_01C47E08.F3526D00 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I’ve just joined this morning and I wonder if anyo= ne could help? I’d like some opinions / war stories / suggestions/ recommendat= ions whatever on PostgreSQL upgrades.

 

We have a PostgreSQL 7.2.1 server on Linux RHL 9 Enterpr= ise / 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 upgr= ade version, not too new and unstable. Which one? 7.4.x? Wait for 7.5? I d= on’t want to do this too often so I would like to space major upgrade inter= vals by at least 12 months if possible.
  • Any really pressing reaso= ns to move off 7.2.x ? Nasty bugs not patches until later versions?
  • 3rd party soft= ware 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
------=_NextPart_000_0016_01C47E08.F3526D00--