PostgreSQL on RDS: How to bulk import data with FK constraints?
Here's a workaround that works for me:

Create the schema then dump the tables only, in order such that no FK constraint checks fail:

pg_dump --username=postgres --data-only --table=table_1 --table=table_2 --table=table_3 --table=... --format=custom foo &gt; foo.dump

pg_restore will now work.