Re: Backup of a big DB with a lot of large objects - Mailing list pgsql-admin

From Milen A. Radev
Subject Re: Backup of a big DB with a lot of large objects
Date
Msg-id ekpon8$clv$1@sea.gmane.org
Whole thread Raw
In response to Re: Backup of a big DB with a lot of large objects  (Steve Holdoway <steve.holdoway@firetrust.com>)
Responses Re: Backup of a big DB with a lot of large objects
List pgsql-admin
Steve Holdoway написа:
> On Thu, 30 Nov 2006 18:12:31 +0200
> "Milen A. Radev" <milen@radev.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

pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: PostgreSQL and Performance of Functions
Next
From: Antonios Katsikadamos
Date:
Subject: producing documentation from postgres file