Steve Holdoway написа: > 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? >> [..] > > Replicate it??? I'm hesitant about replacing backup with replication. It seems to me like trying to shoot a mosquito with a cannon. -- Milen A. Radev
