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@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz