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 1qAf47-0002Dd-5z for pgsql-hackers@arkaria.postgresql.org; Sat, 17 Jun 2023 23:10:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qAf45-00059M-VW for pgsql-hackers@arkaria.postgresql.org; Sat, 17 Jun 2023 23:10:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qAf44-00059C-IU for pgsql-hackers@lists.postgresql.org; Sat, 17 Jun 2023 23:10:41 +0000 Received: from ore.jhcloos.com ([192.40.56.151]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qAf41-00380P-14 for pgsql-hackers@lists.postgresql.org; Sat, 17 Jun 2023 23:10:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jhcloos.com; s=ore17; t=1687043431; bh=zNY4Lp0dYaN8BaVGIDlIMc96dtbdJGC2notXCti41hE=; h=From:To:Subject:Date:From; b=CbInzER2XiD4GX0xO+xP7rABnJy68+dLqjwDGAFOP/RivWOit+7wmEvD8uQjv2NlV hurZXD5Tl0Mqwl7GK66DegKTng7h9BkCDTlfaCMA9PNxW4K2UjRmQmsjybjO7bbgCY HMAUiFeuiHVhFJQiaHf2OO4rj2dZnENU+UXkbuO1jy593/FS9gtDtbbZTTK+DVNFRZ nex43zpkHWB+YAC2tb1mir2IaQ9nH/K56zNkzhNEu7Cm3yjoZd9FD2RMGilWqzjSQf V7s2QQhpIsdDCWm+zjKTzY+a1i7dT/zGx5heFATggChibDhVIHwHdZZv+TS6T/uTc1 75tTPGxe6PJWQ== Received: by ore.jhcloos.com (Postfix, from userid 10) id 9A76D25951; Sat, 17 Jun 2023 23:10:30 +0000 (UTC) Received: by carbon.jhcloos.org (Postfix, from userid 500) id 59DBC12298; Sat, 17 Jun 2023 23:10:23 +0000 (UTC) From: James Cloos To: pgsql-hackers@lists.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: Sat, 17 Jun 2023 19:10:23 -0400 Message-ID: Lines: 15 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 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