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