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 по дате отправления:

Предыдущее
От: "Mitch Vincent"
Дата:
Сообщение: Re: full text searching
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: 7.1beta4 initdb problem