Re: pg_restore error: function plpgsql_call_handler already

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  nickf@ontko.com  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 majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073