Recovering lost large objects?

From: Jakob Borg <jakob(at)borg(dot)pp(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Recovering lost large objects?
Date: 2000-12-03 21:05:49
Message-ID: 20001203220549.A1298@borg.pp.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

After having moved the database directories to a new server, something went
wrong with the large objects. I now have a large number of files named
'xinv<number>' and 'xinx<number>', but trying to lo_open <number> (where
that is a number that was a working large object before) now yields errors
like "lo_open: can't open inv object 9436449".

What I would like is some way to just access all the raw LO-files and
extract the original object from inside them, after which I can insert them
into the database again.

I have not found any information on the file format of the LO-files, nor any
programs to aid in recovering large objects when the index (or whatever it
is that decides that the object no longer exists) is broken.

Anyone who can help?

--
Jakob Borg mailto:jakob(at)borg(dot)pp(dot)se (personal)
UNIX/network admin mailto:jakob(at)debian(dot)org (development)
systems programmer mailto:jakob(at)morotsmedia(dot)se (work)
http://jakob.borg.pp.se/

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Dickhoff 2000-12-03 21:10:40 Re[2]: [Please vote for postgresql!!!]
Previous Message Martin Jacobs 2000-12-03 20:05:36 Re: postmaster of 7.0.3 listening but pslq cannot connect