Re: restore error - language "plperlu" is not trusted

On 17 Dec 2003, Christopher Murtagh wrote:

> Greetings,
>
>  I just had to dump and restore one of my DBs (7.4RC2), and I got an
> interesting message.
>
>  I first did:
>
>  pg_dump dbname > db_restore.sql
>
>  Then at console did the following:
>
>  \i db_restpre.sql
>
>  which performed everything as expected with the following ERROR
> message:
>
> ERROR:  language "plperlu" is not trusted
>
> and it gave a line number, which contained the following:
>
> GRANT ALL ON LANGUAGE plperlu TO postgres WITH GRANT OPTION;
>
> Now, my plperlu functions seem to behaving as expected (they read from
> and write to /tmp). Should I be worried?

Did you install plperlu ahead of time as the super user, then run your
restore as the regular database owner?