ERROR IN RESTORE DATABASE

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

ERROR IN RESTORE DATABASE

JORGE MALDONADO
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.
 
With respect,
Jorge Maldonado
Reply | Threaded
Open this post in threaded view
|

Re: ERROR IN RESTORE DATABASE

Sean Davis
On Tue, Jun 2, 2009 at 12:18 PM, JORGE MALDONADO <[hidden email]> 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

--
Sent via pgsql-novice mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
Reply | Threaded
Open this post in threaded view
|

Re: ERROR IN RESTORE DATABASE

Alan Hodgson
In reply to this post by JORGE MALDONADO
On Tuesday 02 June 2009, JORGE MALDONADO <[hidden email]> 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 means you added the language to the new database before you started your
restore. It's not a problem.

--
I contend that for a nation to try to tax itself into prosperity is like a  
man standing in a bucket and trying to lift himself up by the handle.
 -- Winston Churchill

--
Sent via pgsql-novice mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
Reply | Threaded
Open this post in threaded view
|

Re: ERROR IN RESTORE DATABASE

Tom Lane-2
In reply to this post by JORGE MALDONADO
JORGE MALDONADO <[hidden email]> writes:
> 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;

This doesn't look like a problem --- you just tried to restore into a
database that already had plpgsql set up.  It should have kept going
just fine.

                        regards, tom lane

--
Sent via pgsql-novice mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice