> >> > Allow superuser (dba?) the ability to turn off foreign key checks/all
> >> > constraints/triggers, not settable from postgresql.conf?
> >>
> >> Is that one really necessary for 7.4 now that adding foreign keys is
> >> apparently much faster?
> If you reconfigure your systems to force fsck on every boot, cleanly
> unmounted or not, you can vote against. Otherwise you are basically for
> this option.
I vote to disable the checks for pg_restore if the dumpfile has a check
added to ensure it's the same file that was dumped (an MD5 in the
header) and it is a full database restore.
Individual table restores should require the check.