Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade from PG-14.5 to PG-15.1 failing due to non-existing function - Mailing list pgsql-hackers

From Christoph Moench-Tegeder
Subject Re: pg_upgrade from PG-14.5 to PG-15.1 failing due to non-existing function
Date
Msg-id Y9F9ygEIXkCyHwsL@elch.exwg.net
Whole thread Raw
In response to pg_upgrade from PG-14.5 to PG-15.1 failing due to non-existing function  (Dimos Stamatakis <dimos.stamatakis@servicenow.com>)
Responses Re: pg_upgrade from PG-14.5 to PG-15.1 failing due to non-existing function
List pgsql-hackers
Tree view 
## Dimos Stamatakis (dimos.stamatakis@servicenow.com):

> In our scenario we changed the permissions of this function in PG14.5
> (via an automated tool) and then pg_upgrade tries to change the
> permissions in PG15.1 as well.

Given that this function wasn't even documented and did nothing but
throw an error "function close_lb not implemented" - couldn't you
revert that permissions change for the upgrade? (if it comes to the
worst, a superuser could UPDATE pg_catalog.pg_proc and set proacl
to NULL for that function, but that's not how you manage ACLs in
production, it's for emergency fixing only).

Regards,
Christoph

-- 
Spare Space

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: What object types should be in schemas?
Next
From: Peter Geoghegan
Date:
Subject: Re: [PATCH] Make ON CONFLICT DO NOTHING and ON CONFLICT DO UPDATE consistent