Re: Backup of a big DB with a lot of large objects

Steve Holdoway написа:
> On Thu, 30 Nov 2006 18:12:31 +0200
> "Milen A. Radev" <milen(at)radev(dot)net> 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