Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 6D45686A54B for ; Wed, 18 Jan 2012 18:32:19 -0400 (AST) Received: from [64.207.29.137] (helo=mail.illumen.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rne3C-0001UF-OP for pgsql-admin@postgresql.org; Wed, 18 Jan 2012 22:32:20 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: Upgrading from 9.0.3 to latest Date: Wed, 18 Jan 2012 15:32:00 -0700 Message-ID: In-Reply-To: <4F16F3180200002500044986@gw.wicourts.gov> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Upgrading from 9.0.3 to latest Thread-Index: AczWMHoLcWlLuV35TwCY6XQdd+dXawAAFDSg References: <4F16F3180200002500044986@gw.wicourts.gov> From: "Benjamin Krajmalnik" To: "Kevin Grittner" , "pgsql-admin" X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.207.29.137 (failed) X-Pg-Spam-Score: -1.1 (-) X-Archive-Number: 201201/95 X-Sequence-Number: 39007 If I have never used pg_upgrade, so I believe I do not need to do anything, correct? > -----Original Message----- > From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] > Sent: Wednesday, January 18, 2012 3:28 PM > To: pgsql-admin; Benjamin Krajmalnik > Subject: Re: [ADMIN] Upgrading from 9.0.3 to latest >=20 > "Benjamin Krajmalnik" wrote: >=20 > > I will be taking down all of our infrastructure to update firmware > > on the controllers due to a bug affecting BBU (wonderful J ). > > > > I was thinking of taking the opportunity and upgrading pg from > > 9.0.3 (amd64 on Freebsd 8.1) to the latest version 9.0.6. >=20 > That sounds like a good idea. >=20 > > In the release notes for 9.0.6, it mentions: > > > > fix bugs in information_schema.referential_constraints view (Tom > > Lane) > > > > Is the dropping and recreation of this mandatory, >=20 > If you don't do it, I don't think you're any worse off than you were > while at version 9.0.3; you will just not have fixed the view. >=20 > > can it be done at any time while the server is already being > > pounded with data? >=20 > I would tend to do it as part of the upgrade process. I don't think > it take very long to run. If you do it while queries are running, > you will get errors if any of them reference the information_schema > schema, they will get runtime errors on missing objects. >=20 > Probably more important is to make sure that you have considered > this issue, and taken action if necessary: >=20 > http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix >=20 > -Kevin