Lost large objects
От | Jakob Borg |
---|---|
Тема | Lost large objects |
Дата | |
Msg-id | 20010205173932.A16708@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) friend of laphroaig | http://jakob.borg.pp.se/ (homepage)
В списке pgsql-general по дате отправления: