| From: | Jakob Borg <jakob(at)borg(dot)pp(dot)se> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Lost large objects |
| Date: | 2001-02-05 16:39:33 |
| Message-ID: | 20010205173932.A16708@borg.pp.se |
| Views: | Whole Thread | Raw Message | 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)
friend of laphroaig | http://jakob.borg.pp.se/ (homepage)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-02-05 17:05:53 | Re: 7.1beta4 initdb problem |
| Previous Message | Mitch Vincent | 2001-02-05 16:32:55 | Re: full text searching |