Hi, It's normal to get the message: language "plpgsql" already exists
if 'plpgsql' is already installed in the database and your restore file also has command for installing it. Most times the error is ignored. Maybe you can try out the DB Tools module - http://launchpad.net/db-tools/trunk/0.1/+download/yt_dbtools-20091003.zip Cheers. Mugoma, Yengas. --- On Fri, 11/6/09, [email protected] <[email protected]> wrote: > From: [email protected] <[email protected]> > Subject: [Tinyerp-users] Postgresql Restore returns error > To: [email protected] > Date: Friday, November 6, 2009, 6:09 PM > hi all, > > I have created a brand new db in OpenERP 5.0.6, installed > stock, account, sale, purchase and hr modules, with no demo > data in it. > i dumped all the data for backup purposes which returned an > exit code 0. > when I restored the backup onto a new db i got an exit code > of 1. > here are the errors > pg_restore: connecting to database for restore > pg_restore: creating SCHEMA public > pg_restore: creating COMMENT SCHEMA public > pg_restore: creating PROCEDURAL LANGUAGE plpgsql > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 939; 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; > pg_restore: creating TABLE account_account > pg_restore: creating TABLE account_account_consol_rel ... > .... > ... > WARNING: errors ignored on restore: 1 > > if there had been data in the db the number of errors would > have been in the region of thousands. > the type of dump was compress and blob. > can anyone shed some light please ... the software goes > into sort of production next week and I'd like reliable way > of backing up data, since with the built-in functionality on > WindowsXP does not work ... > > many thanks > luca > > > > > -------------------- m2f -------------------- > > -- > http://www.openobject.com/forum/viewtopic.php?p=46432#46432 > > -------------------- m2f -------------------- > > > _______________________________________________ > Tinyerp-users mailing list > http://tiny.be/mailman2/listinfo/tinyerp-users > _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
