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@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

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