We have a big DB that's backuped nightly using pg_dump in the custom format. Most of its size are several thousand large objects. During the dump of those LO the machine is heavily loaded so we are looking for a way to "optimise" that part of backup process. We had an idea to backup the DB but without the LO and to dump nightly only those LO that were changed or added since the last backup. Unfortunately in v8.1 (we use 8.1.5) there is no way to dump a whole database without the LO. Any ideas for a less taxing backup process? -- Milen A. Radev
