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?

Improve this question

1 Answer 1

Reset to default
1

These errors are harmless and can be ignored.

They stem from COMMENT ON EXTENSION statements in the dump.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.