X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8B37B9DCA78 for ; Thu, 9 Feb 2006 19:08:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56106-08 for ; Thu, 9 Feb 2006 19:08:40 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 1C61E9DC87F for ; Thu, 9 Feb 2006 19:08:36 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k19N8Y3W041465 for ; Thu, 9 Feb 2006 23:08:34 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k19N3wrl040779 for pgsql-admin@postgresql.org; Thu, 9 Feb 2006 19:03:58 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: Upgrading O/S requires Postgres re-build? Date: Thu, 09 Feb 2006 17:18:25 -0500 Organization: cbbrowne Computing Inc Lines: 35 Message-ID: <60hd78fa6m.fsf@dba2.int.libertyrms.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.18 (linux) Cancel-Lock: sha1:YsLgQVlXZtP+gO4bX2rnkTIkJng= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.269 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.171] X-Spam-Score: -1.269 X-Spam-Level: X-Archive-Number: 200602/92 X-Sequence-Number: 20513 htomeh@firstam.com ("Tomeh, Husam") writes: > Server running Postgres 7.4.5 with: > > Red Hat Enterprise Linux AS release 3.90 (Nahant) > Linux 2.6.9-1.648_ELsmp #1 SMP Tue Oct 26 12:24:18 EDT 2004 x86_64 > x86_64 x86_64 GNU/Linux > > I want to upgrade the O/S to: > > Red Hat Enterprise Linux AS release 4 (Nahant) > Linux 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:29:47 EST 2005 x86_64 x86_64 > x86_64 GNU/Linux > > > If I upgrade the O/S to the release stated above, do I need to > re-install and build Postgres 7.4.5? A kernel change shouldn't normally have any impact on whether PostgreSQL would need to be recompiled or not. If all of the libraries that PostgreSQL uses are binary compatible between the two Linux *distribution* releases, then there oughtn't be need to recompile PostgreSQL. And it is reasonably plausible that that would be the case. I'd expect the same PostgreSQL binaries to work; I actually found that RHAT-compiled 32 bit binaries worked on SuSE running on AMD64, which seemed quite remarkable. But I'd be inclined to take a backup before the upgrade just in case any surprises presented themselves... -- let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];; http://cbbrowne.com/info/nonrdbms.html Why does sour cream have an expiration date?