Tim Penhey <tim@penhey.net> writes:
> Maybe it's just me, but I can't seem to get pg_restore to restore a
> database...
It looks to me like you have a bunch of stuff in template1, which is
being duplicated into your test_restored DB and then is interfering
with the restoration of similarly-named objects.
Create the empty database using template0 as template, instead, and
then the restore will work.
regards, tom lane