PythonPython

ERROR: must be owner of extension plpgsql

Apr 25, 2014 · Updated: Nov 04, 2017 · 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:

python
psql template1

then:

python
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 ↓ ↓ ↓