Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 631B086A54B for ; Wed, 18 Jan 2012 18:15:53 -0400 (AST) Received: from [64.207.29.137] (helo=mail.illumen.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RndnM-0001Ee-KF for pgsql-admin@postgresql.org; Wed, 18 Jan 2012 22:15:53 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CCD62E.B5AF1F43" Subject: Upgrading from 9.0.3 to latest Date: Wed, 18 Jan 2012 15:15:39 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Upgrading from 9.0.3 to latest Thread-Index: AczWLrWmFijux6t0TBGNRP4PLufVLQ== From: "Benjamin Krajmalnik" To: "pgsql-admin" X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.207.29.137 (failed) X-Pg-Spam-Score: 1.6 (+) X-Archive-Number: 201201/93 X-Sequence-Number: 39005 This is a multi-part message in MIME format. ------_=_NextPart_001_01CCD62E.B5AF1F43 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. In the release notes for 9.0.6, it mentions: =20 fix bugs in information_schema.referential_constraints view (Tom Lane) =20 Is the dropping and recreation of this mandatory, and if so, can it be done at any time while the server is already being pounded with data? =20 TIA, =20 Benjamin ------_=_NextPart_001_01CCD62E.B5AF1F43 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.

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, and = if so, can it be done at any time while the server is already being = pounded with data?

 

TIA,

 

Benjamin

------_=_NextPart_001_01CCD62E.B5AF1F43--