How to deal with the order of restoring tables?

Question

PostgreSQL

All my life I've been dumping pg_dump bases, and uploading psql base < file
But then I ran into a complex database, where keys in tables point to other tables. As a result, when restoring, I get a bunch of errors like relation "name" does not exist
. And I still don't understand how to solve this ...
The documentation for older versions contains options for managing the restore order, but there is nothing like this in the new ones. Is it possible to dump table by table and restore as well? Absurd!
How to be?

Answer 1

In general, for some unknown reason, the order of restoring tables was not followed. The keys referring to the not yet deployed table were restored to the current table. In theory, everything worked, but who likes mountains of errors?
It was decided by separate recovery of the database schema first (key pg_restore -s), and then only data (pg_restore -a). And of course --disable-triggers

Answer 2

Dump with the -Fc switch and restore with pg_restore. It's 2017, binary dumps, multi-threaded recovery, that's it...