On Thu, 30 Nov 2006 18:12:31 +0200 "Milen A. Radev" <milen@xxxxxxxxx> wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster Replicate it???
