Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qAlYb-0002e5-IB for pgsql-general@arkaria.postgresql.org; Sun, 18 Jun 2023 06:06:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qAlYY-0000bd-H1 for pgsql-general@arkaria.postgresql.org; Sun, 18 Jun 2023 06:06:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qAlYX-0000Ys-Q3 for pgsql-general@lists.postgresql.org; Sun, 18 Jun 2023 06:06:34 +0000 Received: from ore.jhcloos.com ([192.40.56.151]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qAlYS-002pUl-2O for pgsql-general@postgresql.org; Sun, 18 Jun 2023 06:06:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jhcloos.com; s=ore17; t=1687068385; bh=Lg/DQv+8Jw9MAeOzMaZdI1vloDuH7aTRCdrHvlP7TaE=; h=From:To:Subject:Date:From; b=K1cdnKpgwTocnPQ+Yogic1XE/lOXCjAOgnslHs85sjhzgjRo7CMSihvo71k63vn0Q nsvwWOtwFYLOMu/C2bVSiO/GB6yseSfVx5OFxV59Om1F0Zozd3c7OpA7va4fNbBho6 X1v8aWWwqDc3vv0PgDViMaJZQxSwK0qGpvWrTpObZDxfIV92sPnQyjt1zDRY5C+9Qc +YT7LITy9HV+ZL0pkVtSUeHS4nSnv6/eGG0KEt7JumtV5s0WUuptMXs46JD7d3Vp4Z tyJH9zXaZlpwRHwoVjObXaZzhFMFPn0aYJrJept2H7VnYp9QjyI/mk8lysU4Ts7hmG N1lco2nQ1M+FQ== Received: by ore.jhcloos.com (Postfix, from userid 10) id AA65825951; Sun, 18 Jun 2023 06:06:25 +0000 (UTC) Received: by carbon.jhcloos.org (Postfix, from userid 500) id 2A0E9122BB; Sun, 18 Jun 2023 06:06:19 +0000 (UTC) From: James Cloos To: pgsql-general@postgresql.org Subject: =?utf-8?Q?deb=E2=80=99s?= pg_upgradecluster(1) vs streaming replication User-Agent: Gnus/5.13 (Gnus v5.13) Face: iVBORw0KGgoAAAANSUhEUgAAABAAAAAQAgMAAABinRfyAAAACVBMVEX///8ZGXBQKKnCrDQ3 AAAAJElEQVQImWNgQAAXzwQg4SKASgAlXIEEiwsSIYBEcLaAtMEAADJnB+kKcKioAAAAAElFTkSu QmCC Copyright: Copyright 2023 James Cloos OpenPGP: 0x997A9F17ED7DAEA6; url=https://jhcloos.com/public_key/0x997A9F17ED7DAEA6.asc OpenPGP-Fingerprint: E9E9 F828 61A4 6EA9 0F2B 63E7 997A 9F17 ED7D AEA6 Date: Sun, 18 Jun 2023 02:06:19 -0400 Message-ID: Lines: 18 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk [ hmm. i thought i sent this here, not to pgsql-hackers. don't know what happened. resending... ] Has anyone recently tried updating a streaming replication cluster using debian’s pg_upgradecluster(1) on each node? Did things work well? My last attempt (11 to 13, as I recall) had issues and I had to drop and re-install the db on the secondaries. I'd like to avoid that this time... Should I expect things to work easily? -JimC -- James Cloos OpenPGP: 0x997A9F17ED7DAEA6