Re: Lost my blobs and can't restore.

Поиск
Список
Период
Сортировка
От Jerry LeVan
Тема Re: Lost my blobs and can't restore.
Дата
Msg-id CCDB799A-E802-11D8-9CB1-000393779D9C@eku.edu
обсуждение исходный текст
Ответ на Lost my blobs and can't restore.  (Jerry LeVan <jerry.levan@eku.edu>)
Список pgsql-general
Hmmm, still don't know if pg_restore will add the comments back....

Anyway I was able to recover my comments by sql that looks like

insert into pg_description values(22160 , 16404, 0, 'robasnowman.jpg')

the 22160 is the oid that represented the picture 'robasnowman.jpg'
     16404 is the oid that identifies large objects,
         0 is a subclass oid currently 0
     'robasnowman.jpg' or whatever you want is the 'comment'

You have to be superuser to write the table (I think)

Fortunately I am getting ready to release the next version 1.3.3 of
BiggerSQL , it has the capability to display images stored in oids
and bytea fields so I was able to make a reasonable comment.

Jerry


В списке pgsql-general по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: probelm migrating from 7.3.4 to 7.42
Следующее
От: "Kevin Bartz"
Дата:
Сообщение: Re: Out of swap space & memory