Re: Backing Up large object

From: Warwick Hunter <whunter(at)agile(dot)tv>
To: robert(at)rlb3(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Backing Up large object
Date: 2003-01-22 03:24:33
Message-ID: 3E2E0EF1.30904@agile.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Robert,

pg_dumpall doesn't seem to support large objects.
pg_dump will include the large objects in your backup
if you use the --blobs command line option.

Warwick

> How do I backup the large objects? When I pg_dumpall I don't get any of
> the large objects. Do you have to write your own backup script to get them
> out?
> I'm not really sure what to do. Any help would be great.
--
Warwick Hunter Agile TV Corporation
Voice: +61 7 5584 5912 Fax: +61 7 5575 9550
mailto:whunter(at)agile(dot)tv http://www.agile.tv

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew McMillan 2003-01-22 07:23:07 Re: locking mechanism
Previous Message Robert Boone 2003-01-22 03:15:18 Backing Up large object