$ pg_dump [prod_db] > tempfile

[Go through tempfile manually removing all 60ish references to the owner, named 'postgres']

$ cat tempfile > psql [local_db]