"Mark Mikulec" <mm98au(at)brocku(dot)ca> writes:
> Tried pg_dump - still didn't work. So I took tom lane's suggestion, only I
> used the droplang command and after that, it succeeded! Ok, so try to
> restore, I dropped my test database, created it again, then called
> pg_restore on my tar, and I got:
> pg_restore: [archiver (db)] could not execute query: ERROR: function
> plpgsql_call_handler already exists with same argument types
> Which doesn't makes to sense to me, because I dropped the language!
Sounds to me like you have a definition (possibly a broken one) in
the template1 database, where it will be copied by CREATE DATABASE.
regards, tom lane