Re: restore error - language "plperlu" is not trusted - Mailing list pgsql-general

From scott.marlowe
Subject Re: restore error - language "plperlu" is not trusted
Date
Msg-id Pine.LNX.4.33.0312170854530.10028-100000@css120.ihs.com
Whole thread Raw
In response to restore error - language "plperlu" is not trusted  (Christopher Murtagh <christopher.murtagh@mcgill.ca>)
Responses Re: restore error - language "plperlu" is not trusted
List pgsql-general
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?


pgsql-general by date:

Previous
From: "Bob Powell"
Date:
Subject: Excel, OpenOffice and Postgres
Next
From: javier garcia - CEBAS
Date:
Subject: Re: Excel, OpenOffice and Postgres