Recovering lost large objects?
| От | Jakob Borg |
|---|---|
| Тема | Recovering lost large objects? |
| Дата | |
| Msg-id | 20001203220549.A1298@borg.pp.se обсуждение исходный текст |
| Список | 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@borg.pp.se (personal)
UNIX/network admin mailto:jakob@debian.org (development)
systems programmer mailto:jakob@morotsmedia.se (work)
http://jakob.borg.pp.se/
В списке pgsql-general по дате отправления: