Re: ERROR IN RESTORE DATABASE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR IN RESTORE DATABASE
Date: 2009-06-02 16:36:40
Message-ID: 14344.1243960600@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Mohlomi Moloi 2009-06-03 14:40:11 Re: DatabaseMetaData
Previous Message Alan Hodgson 2009-06-02 16:27:10 Re: ERROR IN RESTORE DATABASE