From: Helena Zetterström <helena.zetterstrom@chalmers.se>
To: pgsql-bugs@lists.postgresql.org <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
Date: Wed, 2 Nov 2022 14:47:27 +0000
Message-ID: <3b3fc98f0d004c94b26def11d5e98360@chalmers.se> (raw)
Hi,
In version 15 the functions pg_start_backup()/pg_stop_backup() have been renamed to pg_backup_start()/pg_backup_stop().
If privileges on these functions have been granted in the old cluster the pg_upgrade fails.
Our barman user has been granted 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 before running the pg_upgrade.
No warning/notification is given about this when running pg_upgrade --check.
I don´t know if this is a bug or not but it is really inconvenient to have the pg_upgrade fail/crash (child 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 notification about this could have been shown when running the pg_upgrade with the --check option before performing the actual upgrade.
Best regards,
Helena Zetterström
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: helena.zetterstrom@chalmers.se, pgsql-bugs@lists.postgresql.org
Subject: Re: pg_upgrade fails if privileges have been granted on pg_start_backup()/pg_stop_backup() in the old cluster
In-Reply-To: <3b3fc98f0d004c94b26def11d5e98360@chalmers.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox