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?