If I have to take a guess, it is that you have a language defined in template1 (and hence in the new db) or in the database you are loading into and that is conflicting with the load of the dump.
--------------------------------------------------------------------------- Nick Fankhauser wrote: > Hi- > > I'm trying to do a dump & restore of a complete database using tar archive > format. I've previously used the text dump approach, so I'm very new to this > method. > > I created the dump using: > > pg_dump -Ft alpha > alpha.dump.tar > > > I'm trying to restore into an empty db using: > > pg_restore -d alpha2 alpha.dump.tar > > and I get this error: > > pg_restore: [archiver (db)] could not execute query: ERROR: function > plpgsql_call_handler already exists with same argument types > > I found a brief mention of this error in an old novice list posting, but it > seemed to be connected to a plain text dump file, so I'm still mystified. > > Any thoughts? > > Thanks. > > -Nick > > > > -------------------------------------------------------------------------- > Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 > Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
