Blob error after backup and restore

Поиск
Список
Период
Сортировка
От ÍÁÄ·¸Ôì ÍѧÈØÊÔ§Ëì
Тема Blob error after backup and restore
Дата
Msg-id 20050613110134.4888.qmail@chaiyo.com
обсуждение исходный текст
Ответы Re: Blob error after backup and restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
I have postgresql data [7.4.3]  which has the size of more than 5 Gb. and also contains blob for reporting. I use the
command
pg_restore -d test test.tar

test.tar = 5.5 Gb.
after I try to restore it in another server which has the same environment and use the command
pg_restore -d test test.tar

The database "test" after restoration has the same data but no blob found . What's wrong with my command?
Amrit
Thailand



----------------------------------------------------------------------------------
http://www.chaiyo.com ไชโยเมล์ - ฟรีอีเมล์รูปแบบใหม่ สดใสกว่าเดิม...

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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Windows XP Service startup
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Blob error after backup and restore