Re: TEXT and BLOBS

> I always thought backuping the files and pg_dump would be enough. (I
> was sure there would be a way to restore the blobs out of the files
> when I would need it)
>
> Now I have a table with blob-oid's and the xin* files and I cant
> restore the blobs :-( and noone seems to be able to help me.
>
> I was thinking about writing some tools that scans the tables for
> oid's and save the corresponding blobs to files and restore the
> blobs/update the tables later. But if (WAL) will do it for me I'm also
> looking forward for it. When will it come and where can I find
> information about it ?

Actually there is a version of pg_dump which was written by Philip Warner.
You can download this pg_dump for 7.0.2 from:
ftp://ftp.rhyme.com.au/pub/postgresql/pg_dump/blobs/

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------