ERROR: must be owner of extension plpgsql

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:

psql template1


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:

There's even more:

Subscribe for updates

  • via Twitter: @timonweb
  • old school RSS:
  • or evergreen email ↓ ↓ ↓