From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca> |
Cc: | postgres general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: restore error - language "plperlu" is not trusted |
Date: | 2003-12-17 15:55:29 |
Message-ID: | Pine.LNX.4.33.0312170854530.10028-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-patches |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Powell | 2003-12-17 16:01:46 | Excel, OpenOffice and Postgres |
Previous Message | Doug McNaught | 2003-12-17 14:56:43 | Re: md5 function |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2003-12-17 17:12:11 | Re: [PATCHES] Double Backslash example patch |
Previous Message | Bruce Momjian | 2003-12-17 15:27:58 | Re: fork/exec patch |