Date: Thu, 11 Oct 2012 10:11:36 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Craig Ringer <ringerc@ringerc.id.au>
Cc: Rosser Schwarz <rosser.schwarz@gmail.com>,
	PgSQL ADMIN <pgsql-admin@postgresql.org>
Subject: Re: Pg 8.3.x on RHEL 6.3?
Message-ID: <20121011141136.GJ11892@momjian.us>
References: 
 <CAFnxYwivhRhzsA6N25pM4q267CTZ3QR51Y4Rak0=HkCbV_QOyw@mail.gmail.com>
	<50765388.4060003@ringerc.id.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <50765388.4060003@ringerc.id.au>
User-Agent: Mutt/1.5.20 (2009-06-14)

On Thu, Oct 11, 2012 at 01:05:12PM +0800, Craig Ringer wrote:
> On 10/11/2012 05:15 AM, Rosser Schwarz wrote:
> >In preparation for that effort, I've been asked to avail myself of the
> >collective experience and wisdom of the wider community to see if
> >anyone has seen anything unexpected, or any kind of misbehavior in
> >running 8.3 on RHEL 6.3.
> 
> I've not noticed any reports of issues specific to RHEL 6 on any
> version of Pg here, and would be surprised if any issues were to
> occur.
> 
> Consider retaining your old server for a little while, running as a
> warm standby with log shipping. In the exceedingly unlikely case
> that you do run into issues you can fail back to the old server.
> 
> Migrating from 8.3 to 9.1 or 9.2 isn't a big hurdle, since you're
> already past the implicit-casts-from-text stuff. About the only
> thing really likely to bite you is the bytea_output change to hex,
> and that's a trivial postgresql.conf change if you want to preserve
> the old behaviour while fixing code.
> 
> I can understand not wanting to undertake it at the same time as a
> hardware change, but you should probably schedule it for sooner
> rather than later and start testing on the new version once you're
> on the updated OS & HW.

Also, we expect all users to perform all minor upgrades.  All fixes are
not listed in the release notes, and we don't expect anyone to re-test
after a minor upgrade, considering the criteria we use in adding
anything to a minor release;  see this:

	http://www.postgresql.org/support/versioning/

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +