Re: Heading to final release - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Heading to final release
Date
Msg-id 1066090024.46588.11.camel@jester
Whole thread Raw
In response to Re: Heading to final release  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Heading to final release
Re: Heading to final release
List pgsql-hackers
> >> > 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.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: exponential time growth of handling subqueries
Next
From: Rod Taylor
Date:
Subject: Re: 2-phase commit