Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 92C62632D85 for ; Tue, 11 May 2010 10:29:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 11527-05 for ; Tue, 11 May 2010 13:29:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gunduz.org (ns1.gunduz.org [77.79.103.58]) by mail.postgresql.org (Postfix) with ESMTP id 62C72632BF3 for ; Tue, 11 May 2010 10:29:35 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.gunduz.org (Postfix) with ESMTP id 51E66400046; Tue, 11 May 2010 16:33:29 +0300 (EEST) X-Virus-Scanned: amavisd-new at mail.gunduz.org Received: from mail.gunduz.org ([127.0.0.1]) by localhost (mail.gunduz.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id f5AanSP+bMQ9; Tue, 11 May 2010 16:33:27 +0300 (EEST) Received: from [10.15.1.46] (unknown [84.51.49.52]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.gunduz.org (Postfix) with ESMTPSA id 4A2E040038F; Tue, 11 May 2010 16:33:27 +0300 (EEST) Subject: Re: upgrade proc with pitr standby From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= To: Ray Stell Cc: pgsql-admin@postgresql.org In-Reply-To: <20100511131617.GA17277@cns.vt.edu> References: <20100511131617.GA17277@cns.vt.edu> Content-Type: multipart/signed; micalg="pgp-sha1"; protocol="application/pgp-signature"; boundary="=-2wyVDBJ5GnDsnBjjf6oT" Date: Tue, 11 May 2010 16:29:18 +0300 Message-ID: <1273584558.5575.43.camel@hp-laptop2.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 (2.28.3-1.fc12) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.563 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_BL_SPAMCOP_NET=1.347, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/118 X-Sequence-Number: 34591 --=-2wyVDBJ5GnDsnBjjf6oT Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, 2010-05-11 at 09:16 -0400, Ray Stell wrote: > What are the steps for upgrade of a primary/PITR standby pair to the=20 > latest 8.3 patchset, 8.3.6-8.3.10? I don't see this in the docs.=20 > Should there be something added to 15.4. Upgrading? =20 >=20 > My guess is: > 1. turn off the standby config in primary > 2. upgrade primary > 3. rebuild standby=20 You need to upgrade standby first, restart it. Then, upgrade master and restart it. No need to turn off standby config. Regards, --=20 Devrim G=C3=9CND=C3=9CZ PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz --=-2wyVDBJ5GnDsnBjjf6oT Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEABECAAYFAkvpW60ACgkQtl86P3SPfQ4ufgCfaThGzAWJvcwpWBZHp1eEQT6b faYAnRx91RIMkxPDtca5QrGx3dRaKOKI =sfQU -----END PGP SIGNATURE----- --=-2wyVDBJ5GnDsnBjjf6oT--