Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TM5SF-0004GY-P2 for pgsql-admin@postgresql.org; Wed, 10 Oct 2012 23:12:43 +0000 Received: from plane.gmane.org ([80.91.229.3]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TM5SD-000602-RP for pgsql-admin@postgresql.org; Wed, 10 Oct 2012 23:12:43 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1TM5SG-0000TX-Hw for pgsql-admin@postgresql.org; Thu, 11 Oct 2012 01:12:44 +0200 Received: from cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com ([86.21.186.149]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 11 Oct 2012 01:12:44 +0200 Received: from walterhurry by cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 11 Oct 2012 01:12:44 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Walter Hurry Subject: Re: Pg 8.3.x on RHEL 6.3? Date: Wed, 10 Oct 2012 23:12:26 +0000 (UTC) Lines: 25 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-Pg-Spam-Score: -4.0 (----) X-Archive-Number: 201210/31 X-Sequence-Number: 40147 On Wed, 10 Oct 2012 14:15:15 -0700, Rosser Schwarz wrote: > Fellow Pg Admins, > > At $work, we're preparing to move one of our Pg instances to new > hardware, and considering an OS upgrade at the same time. The instance > in question is running an older version of 8.3, which we'd like to > upgrade to 8.3.latest (presently .21; unf., we don't have the time or > testing resources to migrate to a more recent major release of postgres > as well). > > 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. None of my research suggests we should have any problems, > but for sake of due diligence and checking the box, I'm soliciting any > input anyone with experience with this configuration might be able to > offer. We aren't doing anything that would subject us to the > referential_constraints issue, fixed in 8.3.17. > > Can we expect to see any benefit from the llseek kernel changes with > 8.3, or is the upside of that more limited to people also running 9.2? > OK, I'll do your work for you. $200/hr.