ERROR: must be owner of extension plpgsql

From: x_hsky <x_hsky(at)163(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: ERROR: must be owner of extension plpgsql
Date: 2017-06-15 06:18:18
Message-ID: 657389e4.c9bc.15caa670898.Coremail.x_hsky@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,
Environment：
Centos-6.5 pg-10.0

I used common user to back up the data via pg_dump, then use the same user to restore ,but get the error:
ERROR: must be owner of extension plpgsql

I found 'COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';' from the sql, it need superuser privilege ,why?

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Dubey 2017-06-16 00:41:07 delete hung soon after vacuum verbose analyse
Previous Message John Scalia 2017-06-14 23:18:28 Re: SSL certificate revocation file will not load