Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 159C8B5DC2C for ; Thu, 19 May 2011 10:40:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 12966-03 for ; Thu, 19 May 2011 13:40:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id 13847B5DBEA for ; Thu, 19 May 2011 10:40:09 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 5BAE6118DE0; Thu, 19 May 2011 09:40:09 -0400 (EDT) Date: Thu, 19 May 2011 09:40:09 -0400 From: Ray Stell To: pgsql-admin@postgresql.org Subject: patching the OS of a 9.0.4 db with hot standby Message-ID: <20110519134009.GA16689@cns.vt.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/121 X-Sequence-Number: 37558 I want to do OS patching on prod and hot standby. What is the advised procedure for maintenance on the two systems? I would think patching the standby should come first in case it blows something up. Oracle has a defer switch you can throw on prod to tell it to relax on log shipping to the standby. Do we have that here? Sorry if this is in the fine manual.