Re: TEXT and BLOBS

On Thu, Nov 09, 2000 at 09:00:13AM -0300, Martin A. Marques wrote:
> > I cant speak for PHP, but in perl or in C you have a documented module
> > that will handle this things. (in perl its DBD::Pg). You dont need to
> > save the text to a file first, you can write directely into the blob.
> >
> > The principal things are explained in the postgres-programmers-guide
> > you can find at
> > http://www.at.postgresql.org/devel-corner/docs/programmer/
> > in chapter 16 'Large Objects'
> >
> > Although, dealing with blobs seems to be a dangerous things, cause I
> > didnt find a proper backup-method until now :-(
>
> Which would that method be? I know that with Postgres 7.1 we will have a
> brand new backup system (WAL), so I'm looking forward to it. ;-)
>

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 ?

peter

--
mag. peter pilsl

phone: +43 676 3574035
fax : +43 676 3546512
email: pilsl(at)goldfisch(dot)at
sms : pilsl(at)max(dot)mail(dot)at

pgp-key available