Apr 25, 2014 · Updated: Jul 12, 2021 · by Tim Kamanin
Today while moving Django/PostgreSQL site between servers and importing an SQL dump into the new location I got a surprising error " ERROR: must be owner of extension plpgsql". I'm already used to PostgreSQL quirks so after a quick search I came to the following solution: Login as postgres user and do:
alter role your_role_name with superuser;
That will make your current user as superuser and give him permissions to own plpgsql language.
Hey, if you've found this useful, please share the post to help other folks find it: