"Kasia Tuszynska" <ktuszynska(at)esri(dot)com> writes:
> Description: pg_restore is done in alphabetical order by schema
You have not shown us any actual problem. There is nothing wrong with
restoring the data in the order pg_dump uses, because no triggers or
cross-table constraints have been installed at the time the data is
loaded.
regards, tom lane