How to backup db with large objects? - Mailing list pgsql-general

From Ignas Saltis
Subject How to backup db with large objects?
Date
Msg-id 000001bfcfb4$82c673d0$0a0a0a0a@ignas.sintegra.intra
Whole thread Raw
Responses Re: How to backup db with large objects?  ("Robert B. Easter" <reaster@comptechnews.com>)
List pgsql-general
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.


Sincerely,


Ignas


pgsql-general by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: troubles installing postgresql6.4
Next
From: Travis Bauer
Date:
Subject: Precision of calculated numeric fields