Re: TEXT and BLOBS

From: Peter Pilsl <pilsl(at)goldfisch(dot)at>
To: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
Cc: postgres mailinglist <pgsql-general(at)postgresql(dot)org>
Subject: Re: TEXT and BLOBS
Date: 2000-11-09 13:11:55
Message-ID: 20001109141155.E5576@i3.atat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Perchine 2000-11-09 13:52:23 Re: TEXT and BLOBS
Previous Message Martin A. Marques 2000-11-09 12:55:26 Re: auto increment