Bill McGonigle <mcgonigle(at)medicalmedia(dot)com> writes:
> OK, I wrote a script to split the database backup where on '-- Selected
> TOC Entries:' lines - from the head of each of those, this is
> interesting. If I'm reading this correctly, there are 3 copies of this
> database 'studies' each with their own OID.
> That feels not quite right.
Indeed. Did you perhaps have multiple pg_shadow entries matching the
database's datdba in the old installation?
regards, tom lane