Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tn3mD-001aF0-B2 for pgsql-general@arkaria.postgresql.org; Tue, 25 Feb 2025 22:51:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tn3mC-00AB6j-AH for pgsql-general@arkaria.postgresql.org; Tue, 25 Feb 2025 22:51:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tn3mB-00AB6K-2E for pgsql-general@lists.postgresql.org; Tue, 25 Feb 2025 22:51:43 +0000 Received: from evcspprf12.ads.northwestern.edu ([165.124.82.243]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tn3m6-0004re-0R for pgsql-general@postgresql.org; Tue, 25 Feb 2025 22:51:40 +0000 Received: from pps.filterd (evcspprf12.ads.northwestern.edu [127.0.0.1]) by evcspprf12.ads.northwestern.edu (8.18.1.2/8.18.1.2) with ESMTP id 51PMlooS022751 for ; Tue, 25 Feb 2025 16:51:37 -0600 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=northwestern.edu; h=content-type : date : from : message-id : mime-version : subject : to; s=proofpoint; bh=tdKLKfgMgsgN2x9xM2Qq14++EoFDasc/CMxq4ctJSDE=; b=ClbEl/Fw/9+aVmj2jTSilThweDGgqIz1S+Bh11D2qXUT+NQy3ITK9NuAdkyTUd0s36/c bJH8RmrGycg/ganv8yd5RorErnUOENU3TI3EB8/GvwGUu4IckUvo6Kuplq+m2YcfW/s+ REMXa7wEqmwGtpWFOry/kuiLMKrYVeXyoYflyEt79UyC5tRO7s6cLCrs4H2jWrb8qFlb bjJF9vXbChd04SJndg6ybU02C/2nt2n53LinKb3cqoV12NdxuM4fn51XYwlSPDnN9Won bEYeeQkATZy7QG/ZMrdqeAeuM45lNj4bst59DHyJ99D3aeY5cE/dvtMYDgUPLt6YYKsm mQ== Received: from evcspexch02.ads.northwestern.edu (evcspexch02.ads.northwestern.edu [165.124.43.180]) by evcspprf12.ads.northwestern.edu (PPS) with ESMTPS id 451pyn00p5-2 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Tue, 25 Feb 2025 16:51:37 -0600 Received: from EVCSPEXCH01.ads.northwestern.edu (165.124.43.179) by EVCSPEXCH02.ads.northwestern.edu (165.124.43.180) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11; Tue, 25 Feb 2025 16:51:36 -0600 Received: from BL0PR05CU006.outbound.protection.outlook.com (40.93.2.10) by EVCSPEXCH01.ads.northwestern.edu (165.124.43.179) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11 via Frontend Transport; Tue, 25 Feb 2025 16:51:36 -0600 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=iFH5bpFci1t3MtNsLvTUk6HoKwrMpZ/SA/6JPSs1Ew9mpTqH5TuGHcsMBf/Bym/Na8OQ3r7i0GPHTlg5vBUjYrNULVEEg2jzIp+K7iaxWztqU0YbCYbQXOVzoyHz7m/O6AlKLJidJjB+mMVafICD/KAljKs+BtDhk5+sJJIimaY3grVvM6hah8gY1G1UXuYfUeDPE/2IzrbfzK0h8YwOBBmrWQxzI7azzzQm82n4tk8uqWHKu/HG5xWdZ86YjgcKJQe0cEnWOOAm70SNkeHjI8BvynYaXUgasMBhwueWW4br33SnTvOADpPynwA6W4Sc2Dt4RGocUf3rqlc9sY9EAg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=tdKLKfgMgsgN2x9xM2Qq14++EoFDasc/CMxq4ctJSDE=; b=t7bL5vPjPwpmuC4Rg38WXuYIjqj0UXnWS96Nq8AWhOvytVkQZ0eFFxyNZY1CuzqqRq9/27eugT7EKWKvRJe9FIb6ZZKdn4FzNDTOfzAXbJ5jd+kaLZNSbotzr+lDTpDRIbdDrxO4MXM40RPLbDXEsoQkJyG0yBKwnTnEnenielNXamQxK9+nazqEe1dlBfyLnJUHhA/ezpF2RTlmvgoZAI9V4CzSlW8Ad5DVfThQB+WkAM/fS3Ai7GGxHi7tlVy5CIlwI0Mi7+RE/7AEZlUn0kYfqJpR1yoZ8YAVY9kzrvzny+UQJ9bD4LQpgwVN1wnplRec15TFTSi6sEFCcOjx8Q== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=northwestern.edu; dmarc=pass action=none header.from=northwestern.edu; dkim=pass header.d=northwestern.edu; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=northwestern.edu; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=tdKLKfgMgsgN2x9xM2Qq14++EoFDasc/CMxq4ctJSDE=; b=DsAxrDeSIreyqEMrFin4ns+y92IeisbvkDXwpOnIfDYLSKCz65eaXCY/ufUPSqPV9Q+j64CPbcbhfMCrkhXZDyTxJuWIqhmAWT05lyudm9RgdSTynqV2ulSLI10IlpBwT7o6kPYU0w0EOSDyu0k9SzwHXXG0nRGUUG5C2dD7h5s= Received: from DS0PR05MB10111.namprd05.prod.outlook.com (2603:10b6:8:ff::12) by IA3PR05MB10618.namprd05.prod.outlook.com (2603:10b6:208:536::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8466.20; Tue, 25 Feb 2025 22:51:35 +0000 Received: from DS0PR05MB10111.namprd05.prod.outlook.com ([fe80::787a:6b8f:e3d2:efa5]) by DS0PR05MB10111.namprd05.prod.outlook.com ([fe80::787a:6b8f:e3d2:efa5%7]) with mapi id 15.20.8466.016; Tue, 25 Feb 2025 22:51:35 +0000 From: Martin Mueller To: "pgsql-general@postgresql.org" Subject: rookie question about upgrade from 13 to 17 Thread-Topic: rookie question about upgrade from 13 to 17 Thread-Index: AQHbh9TONLOMQu4nKE+keEs1F8JarA== Date: Tue, 25 Feb 2025 22:51:35 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-reactions: allow x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DS0PR05MB10111:EE_|IA3PR05MB10618:EE_ x-ms-office365-filtering-correlation-id: 6957b980-4994-4a3f-bcb3-08dd55eef49b x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|1800799024|376014|8096899003|38070700018; x-microsoft-antispam-message-info: =?Windows-1252?Q?RGRic44TjNYctd05daVuzplJxgkTUtADBxIn7g2OK+4d/aA1xNY9Vbj8?= =?Windows-1252?Q?zxl3YB0y/S2Ds2mMmrTtl5RB23N3Rytf1BrmSG7CVXoSV1Hp/X2UIAFg?= =?Windows-1252?Q?VPoio+H71WsI1UCYRxL8QgX7fujr+LKYrBckf+NkRg9flgxTOCG4keCv?= =?Windows-1252?Q?O6LJXd5lchVhzpepgHRWssp9dfTh1qOsLVIs4do1ZXiZEUAyyoSNQOW3?= =?Windows-1252?Q?/o3gSX5hYgeVqF/RpxIxdGs2V2B9C7PEJ1x/N3zHtO6n5TB29Vi8mYh9?= =?Windows-1252?Q?zN4fgSbqgeS0rppaVSwX1AsBKf04oGBE+cd30q4RSZCacygdHVx5Zz9B?= =?Windows-1252?Q?zb+NuN/cj1YVi0P2SNhOquvgZEbFj4tO1OpXjp4YUfLOgzvlFUeHMu7D?= =?Windows-1252?Q?Wju0qG3yLKhPbt99fuqFMRjEhsLSHv8glEX2BWGQtozUjMJIV5txmOe0?= =?Windows-1252?Q?zg512vV/p7ZwPIcork89HS6Spg5GkR3ECOmPz+Hul0hRKNgSx8zmYMw7?= =?Windows-1252?Q?LdC/vBeBNsIpX6gF1wO6hkAPUop5fySJPFQXQ51GEgf1ze0w8/yv3Lk3?= =?Windows-1252?Q?u7xzx2Z9re/YmpKDL9fIUnqHCyC8gJhi40I5VUMRmkbopIec/OvwXeBO?= =?Windows-1252?Q?IgPEUyryiIctpwSGbuy6qBrDw+HmlryXt/u5X/SGP14ga8uLl/dUTtVh?= =?Windows-1252?Q?bhOr8YtfLH4pzgZSrjgnAcUmwoYh7wLeDq8HeNBb8LLgvZna7k0JyQ2g?= =?Windows-1252?Q?pkK2Uk3KItsuyTxUrflxppOYIgacSE+IFSEfxDndYW6Y0t61jhog8pDg?= =?Windows-1252?Q?1uWGJkmvA6xNuWd06aXDbzkxIypm8G6mr60gfujl4Y2Rc80gi2zSv5Dy?= =?Windows-1252?Q?ic4D+u95EdI7frAId0Kksi5f9ASGOrordexICA/Yq2BKDJvwk4RmxlNr?= =?Windows-1252?Q?wWGdyDk5fraI4oznmh45Nb4On9r3/vj6bbmfs1nAv+h1Jq1juU9t4/AQ?= =?Windows-1252?Q?DdAI24yssbfOdscdXVAxEh7sm2cSp2fWda6ssjCpQ8vOsWOHyBFvKaos?= =?Windows-1252?Q?lGmjGE3RnNa9fuMO+qR9xZIpyWHbzY9jQfsgdhjTCwUwA8CC8Gm8dRuI?= =?Windows-1252?Q?kwqBuFxcMZmkfQShptEJwPWZvi+lzRlKDzqvgsGwcplU31npOQmdiEz0?= =?Windows-1252?Q?8h/o49npqONGc1kIVZoOXWL/r5ykVkgfbwTpS+FcyROgMGvZhxn+7IFB?= =?Windows-1252?Q?Gzoorl1IsV8gyko5wvPNkR3QqsEGqzgME2sBfHWMmAv0k73eC4Rq+VtD?= =?Windows-1252?Q?Rpk3I66XWZ4PEEQR1r3YnAw+kPncLuRE55DG6XrqNfy6eT8h33YDnwFn?= =?Windows-1252?Q?kWlfDdT7/0FJUkNzzPkoWfICmhvpG/YJ8zoVxRRLdSQ5zvicNIxagJn4?= =?Windows-1252?Q?cPcT0LTwWV/vH0fBVM/BMF35Xou9hPjmn674Z7k95+o82GJmIDDvkOqS?= =?Windows-1252?Q?G7JQuGMOGbJtOKrLJjGvrUmVtSVG5QbqG9Oc0mTgCXvBH/Ioyr38wu5B?= =?Windows-1252?Q?HKMXZYzVaziBuaZx?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DS0PR05MB10111.namprd05.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(8096899003)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?rF4sCSJZH7oT4SVIb7W+UPgvKSUfPiZuVaHZ+4q+GyQqT+Y+g//Ia6gD?= =?Windows-1252?Q?GphC8rlZ4ZpadT8mF/3RiDZzZx3SAKpps6smMNskay1IhFhDULys12kD?= =?Windows-1252?Q?dIKF6GX+FmGvs6yUlPUME5D5URnxMsw770kgXd7oOEqFxjQs4F5O8Dw7?= =?Windows-1252?Q?r/XwPbQK9Vd+vn+lR5vt4t9JqAJN77QSWmkFcdEBlkU8ETdveL8BNgMw?= =?Windows-1252?Q?l5vyin6iesjTXBuQVM2JBe3haQCVxeRH/9hezpc8NGng3DaZMBkxHza8?= =?Windows-1252?Q?hhoTzoI2AnSJQxCm66+8hH00dgpV0WvrC/NFz5hQI0147g+yyndMuT7a?= =?Windows-1252?Q?wc5W3USO/7FaLDKRvlYhXPdaH4U1InB3Qp6OlflbbXPD40YLjDNq1dBF?= =?Windows-1252?Q?sphRKXNfdaUekEJJe7XdfyJbqnWbeXvVHszqWRh8o52vjXOyptXFSNkt?= =?Windows-1252?Q?fJI0Noj3Hf0vDwbPwjn6YlMb9NGtq/PonszCjZ+noqosYog1EFU8efMI?= =?Windows-1252?Q?2g9vy+LIFhobF/PcfL8J4X0SefmQVMQHYZL0drE9H/E5Iu49NBoMasIM?= =?Windows-1252?Q?rAoQ+4Op3v5Jm3QXmn4DfVH1jAQZO4vYgp+hcMm0m/1IjiQLSqwzo0nr?= =?Windows-1252?Q?ICXL4VDZ7vKOPINtegUt8WIoZWTBWHe+poSTfDX/YNrWIBcRLSb2PwkA?= =?Windows-1252?Q?qBAMx1zNW5IyVHCxjzX6EkKJpIHlHKQ4vjzbi0CwQfe6BileUqhPyL3a?= =?Windows-1252?Q?/ZTQkrU7I+MbTCgcoQ6ajETkMwoPNDe0IVuv/MNexPMrxrx6SIcvOzwI?= =?Windows-1252?Q?DKRC6empi8VIMVu7Em432g3n22sbPTxC2+6KRM4ywYnHxkxmEoZb86k2?= =?Windows-1252?Q?NquthooNkM43ZOoVo0QT4wiS1ckPyHbvY1a9RkQ97/uaL5KWhObCEIqM?= =?Windows-1252?Q?PYhex0A3JzqMQyjvCSpSiV2qP/hZoxERe2ynz5p7CvREOH/tXPt8D/iA?= =?Windows-1252?Q?TtVhjJ5qLMLIy/IjIF6Yp9kVCD7a5OLt1Rh8iInd2jGCDqZoCg/EXb9A?= =?Windows-1252?Q?o5hzrmybajOcoDT9JhZKMVv15U+Vkb64f+gT42ccOfzmr7CQCEExcizD?= =?Windows-1252?Q?MXRR05trolmL2g+ncZgwvnynnaKYFoiFf39lPx8r5MF+X+hlPjjxC6R0?= =?Windows-1252?Q?WOVmqr6N2NlA/qo7ThVFz1lgXCBYgEklPTKg2y5sCOYiAZLwAO9hVZ8J?= =?Windows-1252?Q?mX7y5f8jMbZNoSkz1kJ0GjUKQBcvG9YGiXFGpaUrcdKeDvlvQ0Z7R0vO?= =?Windows-1252?Q?R5mrhhUTiV36M802y0u62JXieyk78NZB5KW8Bg1cFuuLO/yp2xRIzII+?= =?Windows-1252?Q?tFb2vg8HwgHw04PnDIAf2BDVClSTXIA5F5dbQ3IYuBOtNxSp9Go3Kre2?= =?Windows-1252?Q?G7z41nndzGetw6VfsUTuGPWYhtwDxiQ5+Nzcs/ybE0IQsIUZchhFRKXR?= =?Windows-1252?Q?jT5ZuO5wUHNtDYjiZHeT+vF2AUEywKa8/JUHflDtZhH9bpmMsWx0HdAR?= =?Windows-1252?Q?ZRKia+kEu3kV6ZS0XNPkPUZLrwe7NzNQvUcCG/cKzeM0Wiu+IG2gEKSv?= =?Windows-1252?Q?1NSAzaD21Ht0zP1qcym1XfN+MJ5wbHSuwIumGm30EB0BC02Jhoz/tTc5?= =?Windows-1252?Q?032ri9az6eD79FuSymy3D5+wbNJMMSKYSRkzEFME4kKW7fqzcUFuoFL5?= =?Windows-1252?Q?IwniOMDSRPc8iZZY0xg=3D?= Content-Type: multipart/alternative; boundary="_000_DS0PR05MB101114074945DF9F482FF0A2FC4C32DS0PR05MB10111na_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DS0PR05MB10111.namprd05.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 6957b980-4994-4a3f-bcb3-08dd55eef49b X-MS-Exchange-CrossTenant-originalarrivaltime: 25 Feb 2025 22:51:35.0415 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 7d76d361-8277-4708-a477-64e8366cd1bc X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 5gBTt+w+kGcbghvMvdVwCOENflfEt+0z5BlEtvCZ9hh/tncDc0NL91q0gatgdEq3+I4btB35HOlScriJxBeUu85D0Vdz7eo4nm68TfDatEo= X-MS-Exchange-Transport-CrossTenantHeadersStamped: IA3PR05MB10618 X-OriginatorOrg: northwestern.edu X-Proofpoint-GUID: mcQGRRTKHGFnTFWBB6x6q34itw9oogpr X-Proofpoint-ORIG-GUID: mcQGRRTKHGFnTFWBB6x6q34itw9oogpr X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1057,Hydra:6.0.680,FMLib:17.12.68.34 definitions=2025-02-25_08,2025-02-25_03,2024-11-22_01 X-Proofpoint-Spam-Reason: safe List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DS0PR05MB101114074945DF9F482FF0A2FC4C32DS0PR05MB10111na_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I would like to update my current version of Postgres13 on a Mac mini to th= e latest version, but I can=92 t find anything in the general document that= explains the procedure in terms readily understand by retired professors o= f English=85 I understand that there are three items involved: 1. The installed instance of version 13 2. The not yet installed instance of version 17 3. The tables (several hundred and adding up to 30 GB when backed with= pg_dump) I also understand that there is a pg_upgrade command that picks up the old = tables and presents them to the later version in a somewhat different forma= t But I don=92t understand how the different steps in the upgrade process int= eract. What are the steps and in what order that wil 1. Install version 17 2. Upgrade the data so that they will in version 17 3. Get rid of the no longer needed version 13 There is a Postgres app for the Mac, but upgrading from one version to ano= ther doesn=92t seem to be part of it. I use postgres exclusively in a single user fashion with a GUI front end, a= s if it were a more powerful version of Microsoft Access. I=92ll gladly volunteer to write up the process in English intelligible to = others like me, and there may be some. With thanks in advance Martin Mueller Professor emeritus of English and Classics Northwestern University --_000_DS0PR05MB101114074945DF9F482FF0A2FC4C32DS0PR05MB10111na_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

I would like to upd= ate my current version of Postgres13 on a Mac mini to the latest version, b= ut I can=92 t find anything in the general document that explains the proce= dure in terms readily understand by retired professors of English=85

 

I understand that t= here are three items involved:

  1. The installed instance of version 13=
  2. The not yet i= nstalled instance of version 17
  3. The tables (several hundred and adding up to 30 GB when&n= bsp; backed  with pg_dump)

 

I also understand t= hat there is a pg_upgrade command that picks up the old tables and presents= them to the later version in a somewhat different format=

 

But I don=92t under= stand how the different steps in the upgrade process interact. What are the= steps and in what order  that wil

  1. Install version 17=
  2. Upgrade the data so that they w= ill in version 17
  3. Get rid of the no longer needed version 13

 

There is a Postgres= app for the Mac, but upgrading from one version  to another doesn=92t= seem to be part of it.

 

I use postgres excl= usively in a single user fashion with a GUI front end, as if it were a more= powerful version of Microsoft Access.

 

I=92ll gladly volun= teer to write up the process in English intelligible to others like me, and= there may be some.

 

With thanks in adva= nce

 

 

Martin Mueller=

Professor emeritus of English an= d Classics

Northwestern University

 

 

 

--_000_DS0PR05MB101114074945DF9F482FF0A2FC4C32DS0PR05MB10111na_--