Re: BUG #18625: user-created extensions change ownership to "postgres" after upgrade - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18625: user-created extensions change ownership to "postgres" after upgrade
Date
Msg-id 2422972.1726841792@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18625: user-created extensions change ownership to "postgres" after upgrade  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18625: user-created extensions change ownership to "postgres" after upgrade
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> when upgrading 15 to 16 (but also observed the same on 12 to 13), an
> extension that was previously created by a "normal" user is now owned by
> "postgres":

Yeah, this is a known shortcoming --- pg_dump doesn't make any effort
to preserve ownership of extensions.  Nobody's really been motivated
to do something about that.

            regards, tom lane



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18626: Using ampersand (&) in password fails installation.
Next
From: Evgeni Golov
Date:
Subject: Re: BUG #18625: user-created extensions change ownership to "postgres" after upgrade