Skip site navigation (1) Skip section navigation (2)

Re: large objects dump

From: Denis Perchine <dyp(at)perchine(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: large objects dump
Date: 2001-06-06 05:07:36
Message-ID: 20010606045727.3C13D1C49C@mx.webmailstation.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

> I had PostgreSQL 7.0.3 (7.1 now) and one nice day I've noticed that much
> number of my BLOBs are broken! Although they seems to be with good content
> in file system (xinv[0-9]+ files) I was not able to get them via
> lo_export... After spending some time trying to fix it, I decided to write
> my own xinv2plainfile converter. I hope if someone has same troubles this
> converter will help him.
> Just compile it, put it in the dir with your xinv[0-9]+ files and run.
> It will create new files with name eq to BLOB id from apropriate xinv.

Either use 7.1.x, or apply my patch to 7.0.3. And you will have no such 
problems at all. :-))

-- 
Sincerely Yours,
Denis Perchine

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

In response to

Responses

pgsql-hackers by date

Next:From: prasanna venkatesanDate: 2001-06-06 06:37:59
Subject: capturing stored procedure return values from php??please help .
Previous:From: Bruce MomjianDate: 2001-06-06 04:54:01
Subject: Re: Imperfect solutions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group