Postgres Pro
Downloads
Home   >   mailing lists

BUG #18376: pg_upgrade fails trying to restore privileges on retired function pg_start_backup and pg_stop_backup - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18376: pg_upgrade fails trying to restore privileges on retired function pg_start_backup and pg_stop_backup
Date
Msg-id 18376-d420b8068805622e@postgresql.org
Whole thread Raw
Responses Re: BUG #18376: pg_upgrade fails trying to restore privileges on retired function pg_start_backup and pg_stop_backup  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      18376
Logged by:          Marc Rechté
Email address:      mrechte@gmail.com
PostgreSQL version: 16.2
Operating system:   RHEL 8 (clone)
Description:

We got a pg_upgrade failure when upgrading from a PG14 to a PG16 instance:

pg_restore: de l'entrée TOC 3279 ; 0 0 ACL FUNCTION
"pg_start_backup"("label" "text", "fast" boolean, "exclusive" boolean)
postgres
pg_restore: erreur : could not execute query: ERROR:  function
pg_catalog.pg_start_backup(text, boolean, boolean) does not exist
La commande était : GRANT ALL ON FUNCTION
"pg_catalog"."pg_start_backup"("label" "text", "fast" boolean, "exclusive"
boolean) TO "barman";

Those functions being dropped in PG15, one should not try to restore
privileges on them.

pgsql-bugs by date:

Previous
From:
Date:
Subject: RE:Undetected deadlock between client backend and startup processes on a standby (Previously, Undetected deadlock between primary and standby processes)
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: BUG #18369: logical decoding core on AssertTXNLsnOrder()