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 1oqFwH-0000pg-MY for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Nov 2022 15:46:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oqFwG-0005Mz-Ej for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Nov 2022 15:46:00 +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 1oqF1p-0005Iv-VQ for pgsql-bugs@lists.postgresql.org; Wed, 02 Nov 2022 14:47:42 +0000 Received: from mail-swedencentralazon11022024.outbound.protection.outlook.com ([52.101.82.24] helo=emea01-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oqF1l-0001l6-5S for pgsql-bugs@lists.postgresql.org; Wed, 02 Nov 2022 14:47:41 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ekNG3oXNr6S6SOWjkE33HZ97D7ZQVjcbnqcrwPlMP89bBiBKaCTjIzafr1jAz/DAM1AiTinzE4Bc9Rspky7D8j7Ev3iz3DreWJetulUcO26PSlv76oXJUAejlAvUFAiNY6pDixvisNS1cvapzZLWmUj/mNZHxJlUxfAxGmOT9owNHu2Cjc7LtxPReE6GhE19vTf89vqTnxtrfI6xIauXxImUs2cg2nk57n50i3mRxTFdgVM3fKN2YkhOijOG3S28PjLvQ7we4nW7xAxEyWidJ2ALN63G+qTjRE5SoxWFrLTFgbJgZw+Wc9k7bNiUIxCANbOtCllYBcilX4z8lb/5Aw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; 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=xopu3HBWBblkLSWUtH/Y6A2W2lKxAdWbodIVKukpT6U=; b=agMJTHuK2BTzQn7YcD2gwoSbPwJasc/BWWNhgb7EOn8dsD4txpyJiVUX4TlgqXgh5eE9fJasgtfw2xT/cxy2a1QtfkVVuQICpciXxGqIi9uh/NksF3aAI7VQw8VpedNzDHlhuVXOmggJLtUC4OzVsSy/PNOzTtJtZvwxvRgG7e7FHyuFRWCHPbApiPH+VtYjmWbZ1iiJXqBjoI76Yzm/gGnhAxg+3ulnJbITQKm17EupXthc9bgp0187Q7/0cwdNA9rBMH4RF1Qag4KdTRmUXuxzvvuG3dIn4oM73xXscQIxHqesl5V++LeIOLnU+iE7XHhYxl5+Um8RnxF0Oadgbg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass (sender ip is 129.16.226.138) smtp.rcpttodomain=lists.postgresql.org smtp.mailfrom=chalmers.se; dmarc=bestguesspass action=none header.from=chalmers.se; dkim=none (message not signed); arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=chalmers.se; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=xopu3HBWBblkLSWUtH/Y6A2W2lKxAdWbodIVKukpT6U=; b=uUwIr3dGE2O+34bmTrGfsP9UBLEpWoybeBPujitBOduLyYZTfL+qd9U8aP8YKApzc5VxVpVzG8xtadSoRfEV/R6/FYJFPKJbBrUZFduqngqZdE5BUSE/pKjkej7Nzx3fcDPHpqyH/HvhYUTlpiesPJfTn99CsibAvUhw9Im+OK5aYIMU/QTpOp9hrxVMeIFxe/n6Ayq0GL/HdWk75wzMbxqROWuMyd4J+QDZK/ZfdcTfK2ekjtfbYuMdkX/kyqKEMnzwShwYduGmHxceRX34Onq7yPEf8OZmRaA30QZ9XuqKnqMmREHhgW9ovhXqEiV+tV9w6UeWDCj+fFYTghd99A== Received: from AM6P192CA0070.EURP192.PROD.OUTLOOK.COM (2603:10a6:209:82::47) by GVZP280MB0823.SWEP280.PROD.OUTLOOK.COM (2603:10a6:150:f4::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5791.22; Wed, 2 Nov 2022 14:47:28 +0000 Received: from VI1EUR05FT033.eop-eur05.prod.protection.outlook.com (2603:10a6:209:82:cafe::79) by AM6P192CA0070.outlook.office365.com (2603:10a6:209:82::47) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5791.20 via Frontend Transport; Wed, 2 Nov 2022 14:47:28 +0000 X-MS-Exchange-Authentication-Results: spf=pass (sender IP is 129.16.226.138) smtp.mailfrom=chalmers.se; dkim=none (message not signed) header.d=none;dmarc=bestguesspass action=none header.from=chalmers.se; Received-SPF: Pass (protection.outlook.com: domain of chalmers.se designates 129.16.226.138 as permitted sender) receiver=protection.outlook.com; client-ip=129.16.226.138; helo=autodiscover.chalmers.se; pr=C Received: from autodiscover.chalmers.se (129.16.226.138) by VI1EUR05FT033.mail.protection.outlook.com (10.233.243.184) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.5791.20 via Frontend Transport; Wed, 2 Nov 2022 14:47:27 +0000 Received: from greyjoy.ita.chalmers.se (129.16.226.137) by arryn.ita.chalmers.se (129.16.226.138) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.1.2375.24; Wed, 2 Nov 2022 15:47:27 +0100 Received: from greyjoy.ita.chalmers.se ([129.16.226.137]) by greyjoy.ita.chalmers.se ([129.16.226.137]) with mapi id 15.01.2375.024; Wed, 2 Nov 2022 15:47:27 +0100 From: =?iso-8859-1?Q?Helena_Zetterstr=F6m?= To: "pgsql-bugs@lists.postgresql.org" Subject: pg_upgrade fails if privileges have been granted on pg_start_backup()/pg_stop_backup() in the old cluster Thread-Topic: pg_upgrade fails if privileges have been granted on pg_start_backup()/pg_stop_backup() in the old cluster Thread-Index: AdjuyQXrgSNnDkuyQSaf2xWDeMC2uQ== Date: Wed, 2 Nov 2022 14:47:27 +0000 Message-ID: <3b3fc98f0d004c94b26def11d5e98360@chalmers.se> Accept-Language: sv-SE, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [129.16.10.245] Content-Type: multipart/alternative; boundary="_000_3b3fc98f0d004c94b26def11d5e98360chalmersse_" MIME-Version: 1.0 X-EOPAttributedMessage: 0 X-MS-PublicTrafficType: Email X-MS-TrafficTypeDiagnostic: VI1EUR05FT033:EE_|GVZP280MB0823:EE_ X-MS-Office365-Filtering-Correlation-Id: 3939e676-4b40-495b-0fae-08dabce129c1 X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: BgzXN16WdJ+PkNgvESj2nvDp7h+CCQMqg7Os1nayZ3M9POvUUn2v0LXaGxHyjJKy0oggRcLI1ofWcqAtEtokj/9s7W2uiufRLOYYDHu4JxwVBO6d02MqtEodGXdrCp6YHbWRZyjEMqLSvk3keKCF7jMMBYVt7F8HWZ3Q8EhecpiNmwchR5yivmUEx/fqCLtvt2v+bfJG/r9P0IXlmCgVfSnkSjRw3ffPn9500oCHfq4cAgwsO9TjVLid9+JyJVjC8imqkb9m4Q5RZwqTwfhgXhv/BOcmjht3HRjntCTtJRrIE70tXq6U9vK03XD2OnX255UCgLciSAx3Xl4xkiGwhiZEASMkvTxtgc4Nya1XyR2+/+X0b2HHhYTpwZpg0zGrrdogRXYQDLuD5LFzZQ8tdSXSesFknvdbhm6uYiXEmSAHBdtRazf9OWAQCZs0V/VAZTJAMlX/nRGQ4hPbu4UcnqkbaWHvOBlUbQnvYWpIueAlaYSs5Sm3eKTbanZEK4u6Au8SQAbO5kYFtgQwQnzq3sbfiLP4wBqc608zYKhqX0GAXoMJeSWWrwLRkFiEenFuVnHWdTUqZaKyyd4LVNzO1u2Rzyj0aMMSQe8mCqNsG68Bp+nhy4ckIuB7UeTUXKRo+u6ZwlIcrLC+pZj60b7YAJDIGqYHhGGBmmN+hNIvAuEBy3YcL/3fWABQd5LYJuhmCN5Qt4YLMAd/ui/T9zUm/5gIoMBZyDCU62qf4in+WCttwRamPPIo+RP6yvMPIx0Kp2HeKh35iAiaS+MNqP8CXA== X-Forefront-Antispam-Report: CIP:129.16.226.138;CTRY:SE;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:autodiscover.chalmers.se;PTR:arryn.ita.chalmers.se;CAT:NONE;SFS:(13230022)(4636009)(346002)(376002)(136003)(396003)(39860400002)(451199015)(36840700001)(40470700004)(46966006)(66574015)(47076005)(426003)(2906002)(83380400001)(86362001)(40460700003)(36756003)(41300700001)(70586007)(26005)(70206006)(8676002)(40480700001)(82310400005)(36860700001)(786003)(316002)(82740400003)(336012)(7636003)(356005)(6916009)(5660300002)(8936002)(2616005)(186003)(956004)(7696005)(24736004)(108616005)(478600001);DIR:OUT;SFP:1102; X-OriginatorOrg: chalmers.se X-MS-Exchange-CrossTenant-OriginalArrivalTime: 02 Nov 2022 14:47:27.9747 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: 3939e676-4b40-495b-0fae-08dabce129c1 X-MS-Exchange-CrossTenant-Id: 29147a65-536d-43f9-b802-e0a1b5cf9dbf X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=29147a65-536d-43f9-b802-e0a1b5cf9dbf;Ip=[129.16.226.138];Helo=[autodiscover.chalmers.se] X-MS-Exchange-CrossTenant-AuthSource: VI1EUR05FT033.eop-eur05.prod.protection.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: GVZP280MB0823 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_3b3fc98f0d004c94b26def11d5e98360chalmersse_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, In version 15 the functions pg_start_backup()/pg_stop_backup() have been re= named to pg_backup_start()/pg_backup_stop(). If privileges on these functions have been granted in the old cluster the p= g_upgrade fails. Our barman user has been granted execute priviliges on these function in Po= stgreSQL 14 and to avoid the pg_upgrade to fail we had to revoke these priv= ileges in the old cluster before running the pg_upgrade. No warning/notification is given about this when running pg_upgrade --check= . I don=B4t know if this is a bug or not but it is really inconvenient to hav= e the pg_upgrade fail/crash (child process exited abnormally: status 256) d= ue to it being unable to grant execute on these no longer existing function= s. It would have been good if a notification about this could have been shown = when running the pg_upgrade with the --check option before performing the a= ctual upgrade. Best regards, Helena Zetterstr=F6m --_000_3b3fc98f0d004c94b26def11d5e98360chalmersse_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

 

In version 15 the functions pg_= start_backup()/pg_stop_backup() have been renamed to pg_backup_start()/pg_b= ackup_stop().

 

If privileges on these function= s have been granted in the old cluster the pg_upgrade fails.

Our barman user has been grante= d execute priviliges on these function in PostgreSQL 14 and to avoid the pg= _upgrade to fail we had to revoke these privileges in the old cluster befor= e running the pg_upgrade.

No warning/notification is give= n about this when running pg_upgrade --check.

I don=B4t know if this is a bug= or not but it is really inconvenient to have the pg_upgrade fail/crash (ch= ild process exited abnormally: status 256) due to it being unable to grant = execute on these no longer existing functions.

It would have been good if a no= tification about this could have been shown when running the pg_upgrade wit= h the --check option before performing the actual upgrade.

 

Best regards,

Helena Zetterstr=F6m

 

 

--_000_3b3fc98f0d004c94b26def11d5e98360chalmersse_--