Howard Cole <howardnews@selestial.com> writes:
> To improve compatibility, I created a backup on the linux system
> (8.0.1) using plain format, data only with triggers disabled. However,
> when I try to restore the plain sql on the windows machine (8.0.3) it
> fails because the first insert command fails a foreign key
> constraint. Can I disable foreign key checks for the duration of the
> restore?
I would suggest upgrading to 8.0.3 on the linux machine, just to make
sure you get all pg_dump bugfixes, then retrying the dump/restore.
AFAIK there's no reason it shouldn't work. If you still have trouble,
post the exact dump and restore commands you're using and the exact
error message you get.
-Doug