Re: pg_restore peculiarities

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