How to backup db with large objects?

From: "Ignas Saltis" <ignas(dot)saltis(at)sintegra(dot)lt>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to backup db with large objects?
Date: 2000-06-06 12:41:17
Message-ID: 000001bfcfb4$82c673d0$0a0a0a0a@ignas.sintegra.intra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Travis Bauer 2000-06-06 13:37:52 Precision of calculated numeric fields
Previous Message Marcos Lloret 2000-06-06 12:07:45 troubles installing postgresql6.4