[ADMIN] ERROR: must be owner of extension plpgsql - Mailing list pgsql-admin

From x_hsky
Subject [ADMIN] ERROR: must be owner of extension plpgsql
Date
Msg-id 657389e4.c9bc.15caa670898.Coremail.x_hsky@163.com
Whole thread Raw
List 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?


 

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: [ADMIN] SSL certificate revocation file will not load
Next
From: Simon Dubey
Date:
Subject: [ADMIN] delete hung soon after vacuum verbose analyse