Re: TEXT and BLOBS - Mailing list pgsql-general

From Denis Perchine
Subject Re: TEXT and BLOBS
Date
Msg-id 0011091952230D.21591@dyp.perchine.com
Whole thread Raw
In response to Re: TEXT and BLOBS  (Peter Pilsl <pilsl@goldfisch.at>)
List pgsql-general
> 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@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

pgsql-general by date:

Previous
From: Peter Pilsl
Date:
Subject: Re: TEXT and BLOBS
Next
From: Jan Wieck
Date:
Subject: Re: how do you call one pltcl function from another?