I have serveral tables that they have more then 2 millions,
I want dump they out from one server and then restore them back on
another server every day, the questions are:
1. What is the fastest way to dump/restore my data, I am try to use: pg_dump -aRt mytable -Fc -f mytable dbname
pg_restore-aRt mytable -d dbname mytable but this takes too long to restore.
2. Is any way to disable unique index checking when loading, then enable the index after restored?
Jie Liang