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.
CREATE EXTENSION aiven_extras CASCADE;
Claim the public schema ownership with the dedicated
SELECT * FROM aiven_extras.claim_public_schema_ownership();
avnadmin user owns the public schema and can modify it.