Re: How to backup db with large objects?

On Tue, 06 Jun 2000, Ignas Saltis wrote:
> Hello,
>
> I have database with large objects?
>
> I did following:
>
> pg_dump database1 > database.out
> createdb database2
> psql -e database2 < database.out
>
> And I can not access any large objects on database2.
>
>
> database2=# select lo_export(picture_immage, '/home/postgres/image2.jpg')
> from pictures where picture_id = 6;
> ERROR:  Relation 390625 does not exist
>
>
>
> Do I need to make backup using some special ways?
> I can't find anything in docs.
>
> Any suggestions.

pg_dump/all do not dump the large objects (AFAIK).

ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.4.tar.gz
might help you

--
Robert B. Easter
reaster@comptechnews.com