Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to backup db with large objects?

How to backup db with large objects?

From
"Ignas Saltis"
Date:
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

Re: How to backup db with large objects?

From
"Robert B. Easter"
Date:
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

Re: How to backup db with large objects?

From
Karel Zak
Date:

On Tue, 6 Jun 2000, Robert B. Easter wrote:

> 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

 Nice. Not announced, but users know it :-)

 Test it anyone with 7.0?

                Karel

/* ----------------
 * Karel Zak  *  zakkr@zf.jcu.cz  *  http://home.zf.jcu.cz/~zakkr/
 *           C, PostgreSQL, PHP, WWW, http://docs.linux.cz
 * ----------------
 */