Re: ERROR IN RESTORE DATABASE - Mailing list pgsql-novice

From Sean Davis
Subject Re: ERROR IN RESTORE DATABASE
Date
Msg-id 264855a00906020926s6862ce16udb170139228f1989@mail.gmail.com
Whole thread Raw
In response to ERROR IN RESTORE DATABASE  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
On Tue, Jun 2, 2009 at 12:18 PM, JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
> I made a backup of my database and a restore in a different PC and I am
> getting the following error message:
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 369; 2612 16386 PROCEDURAL
> LANGUAGE plpgsql postgres
> pg_restore: [archiver (db)] could not execute query: ERROR:  language
> "plpgsql" already exists
>     Command was: CREATE PROCEDURAL LANGUAGE plpgsql;
>
> When I open the restored database I can see all of the objects in it:
> schema, tables, keys, etc. so I do not know what this error means; it seems
> that everything is fine. I will appreciate any advice.

It looks like the database to which you restored already had plpgsql
in place.  The error just states that.  So, I don't think there is any
problem and you can assume that you got your database restored.

Sean

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: ERROR IN RESTORE DATABASE
Next
From: Alan Hodgson
Date:
Subject: Re: ERROR IN RESTORE DATABASE