pg_restore error

Поиск
Список
Период
Сортировка
Искать
От
Düster Horst
Тема
pg_restore error
Дата
Msg-id
5B025B1F39D6D4119F5700508BEEEC66F94BF4@SRSOFAIOI4546
Список
Дерево обсуждения
Re: pg_restore error "Lee Wu" <Lwu@mxlogic.com>
Hallo

I try to restore a large DB with BLOBS. I created the dump file with:

pg_dump -Fc -b  > dump.file

During the restore process startet with the following command:

pg_restore -d  dump.file

the process breakes with the error message that a table couldn't be found.
So I started the pg_restore in verbose mode. This mode offers the problem.
pg_restore tries to create a view but a referenced table does not exists. I
thought, that pg_restore will organize the restore-prozess in an optimal
order. This seems not work correct!!?? I would be grateful to hear any
hints. 

My system:
Postgresql 7.4.5
SuSe 9.1 Linux

With best regards
Horst Düster
В списке pgsql-admin по дате отправления
От: Ivan Dimitrov
Дата:
Сообщение: pg_autovacuum is not working
От: Vishal Kashyap @ [Sai Hertz And Control Systems]
Дата:
Сообщение: Re: pg_restore error
FAQ