Claim public schema ownership
When an Aiven for PostgreSQL® instance is created, the public
schema
is owned by the postgres
user that is available only to Aiven for
management purposes. If changes to the public
schema are required, you
can claim the ownership using the aiven_extras
extension as the
avnadmin
database user.
-
Enable the
aiven_extras
extension:CREATE EXTENSION aiven_extras CASCADE;
-
Claim the public schema ownership with the dedicated
claim_public_schema_ownership
function:SELECT * FROM aiven_extras.claim_public_schema_ownership();
Now the avnadmin
user owns the public schema and can modify it.