0

I am following this to restore an externally backed up Postgres DB onto my RDS instance - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.html

However, when I try to restore I get the following errors -

CREATE EXTENSION
psql:database.sql:2615: ERROR:  must be owner of extension plpgsql
CREATE EXTENSION
psql:database.sql:2629: ERROR:  must be owner of extension pg_trgm

I believe this has to do with assigning superuser privileges to the user. However, I know this is not possible to do in RDS. How can I workaround this?

1 Answer 1

1

These errors are harmless and can be ignored.

They stem from COMMENT ON EXTENSION statements in the dump.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.