| From: | Steve Holdoway <steve(dot)holdoway(at)firetrust(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Backup of a big DB with a lot of large objects |
| Date: | 2006-11-30 20:04:09 |
| Message-ID: | 20061201090409.d3dcfd44.steve.holdoway@firetrust.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?
>
> --
> Milen A. Radev
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
Replicate it???
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aaron Bono | 2006-11-30 21:28:04 | PostgreSQL and Performance of Functions |
| Previous Message | Milen A. Radev | 2006-11-30 16:12:31 | Backup of a big DB with a lot of large objects |