Thread: Backup of db with large objects.

Hi,
pg_dump doesn't support large objects, I haven't found any advise how to
do it in doc neither in FAQ. How an I to backup a db with large objects
without losing my data?

mazek

On 2000-02-18, M.Mazurek@poznan.multinet.pl mentioned:

> pg_dump doesn't support large objects, I haven't found any advise how
> to do it in doc neither in FAQ. How an I to backup a db with large
> objects without losing my data?

You need to write a C program using libpq's lo_import and lo_export
functions.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

On Sat, 19 Feb 2000, Peter Eisentraut wrote:

> On 2000-02-18, M.Mazurek@poznan.multinet.pl mentioned:
>
> > pg_dump doesn't support large objects, I haven't found any advise how
> > to do it in doc neither in FAQ. How an I to backup a db with large
> > objects without losing my data?
>
> You need to write a C program using libpq's lo_import and lo_export
> functions.

 ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.3.tar.gz

 (..still available for PG's contrib, Wanted?)

                        Karel

On Mon, 21 Feb 2000, Karel Zak - Zakkr wrote:
> > > pg_dump doesn't support large objects, I haven't found any advise how
> > > to do it in doc neither in FAQ. How an I to backup a db with large
> > > objects without losing my data?
> > You need to write a C program using libpq's lo_import and lo_export
> > functions.
>
>  ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.3.tar.gz
>
>  (..still available for PG's contrib, Wanted?)
Frankly speaking I was surprised theres no such a thing at least in
contrib... unlesss there are some strong agruments for not doing it.

thx
mazek