[GENERAL] How to backup db with large objects?

[Ignas Saltis]

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