CODEWITHSUNDEEP
postgresqlamazon-rds
Shamseer PC
Shamseer PC

Reputation: 817

must be owner of extension plpgsql error when executing pg_restore

i was trying to restore database on amazon rds.. i am getting error message like:

ERROR:  must be owner of extension plpgsql CREATE EXTENSION
ERROR:  must be owner of extension dblink  CREATE EXTENSION
ERROR:  must be owner of extension pgcrypto

Any idea how to solve this issue ?.

Upvotes: 15

Views: 7409

Answers (1)

Francisco1844
Francisco1844

Reputation: 1218

I believe both of those extensions are supported by RDS. See:

$SHOW rds.extensions;

Retrieved from this link

As for enabling the syntax should be along the lines of

#enable_extension "dblink";

As Craig Ringer mentioned rds_super isn't a real superuser. So, you can't create the extensions. However, you should be able to enable them.

As in this example

So, you can ignore the errors, but need to manually enable whatever extensions you need. Also I think pl/pgsql may be already there. Try

$\dx

Upvotes: 1

Related Questions