Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> I wonder if there's any use for an allow_large_objects = true/false GUC
> parameter?

> It'd be nice to be able to switch it off as part of site policy so that
> the security holes in it aren't able to be exposed, plus you can
> guarantee as the site admin that pg_dumpall will produce a complete
> dump.

Security holes? Explain yourself please.

As for the latter point, ISTM the todo item is "fix pg_dumpall" more
than "eliminate large objects". Certainly the fix isn't easy, but
that isn't an argument to cut and run.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings