Re: problems with pg_dumplo (was Re: backup with blobs)

On Fri, Apr 20, 2001 at 02:12:23AM +0200, Peter Pilsl wrote:
> On Wed, Apr 18, 2001 at 06:07:33PM -0400, Tom Lane wrote:
> >
> > No need to re-invent the wheel; use the attached.
> >
>
> Thanx to Tom for this great tool.

Sure :-)

> Unfortunately it does not work in my testenvironment.
> When importing the blobs again, I always get the following error:
>
> lupo:/tmp/pgdump_lo # pg_dumplo -i -d peter -s ./ -u user -p pass
> 66611 blobtest lo_oid peter/blobtest/lo_oid/66611
> 66707 blobtest lo_oid peter/blobtest/lo_oid/66707
> 66867 blobtest lo_oid peter/blobtest/lo_oid/66867
> <skip approx.10 lines>
> 70579 blobtest lo_oid peter/blobtest/lo_oid/70579
> 70643 blobtest lo_oid peter/blobtest/lo_oid/70643
> pg_dumplo: lo_import: can't create inv object for ".//peter/blobtest/lo_oid/70643"
>
> pg_dumplo: ROLLBACK

What do you do before this import?

pg_dumplo -i (without -r) add *new* LO to DB and update LO oid in some
tab.attr only. The option '-r' remove old LO and import new.

Try:

pg_dumplo -a -d my_db -s /my_dump/dir

pg_dump [with relevant options for your DB] > my.dump

DROP DATABASE my_db;

CREATE DATABASE my_db;

psql my_db < my.dump

pg_dumplo -i -d my_db -s /my_dump/dir

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz