must be owner of extension plpgsql error when executing pg_restore

user_1960035 0
Viewed 5989

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 ?.

amazon-rds postgresql
1 Answers

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
user_13107660
Related