Re: pg_dump/pg_restore

Поиск
Список
Период
Сортировка
От Tino Schwarze
Тема Re: pg_dump/pg_restore
Дата
Msg-id 20080408204401.GC30442@easy2.in-chemnitz.de
обсуждение исходный текст
Ответ на pg_dump/pg_restore  ("Sergio Gabriel Rodriguez" <sgrodriguez@gmail.com>)
Список pgsql-admin
On Tue, Apr 08, 2008 at 04:52:23PM -0300, Sergio Gabriel Rodriguez wrote:

> I'm using postgresql 7.4, I have a problem with pg_dump/pg_restore. I
> want to back and restore only one schema from my db (I did it), but
> when I restore it, postgresql found errors in some views, this ones
> needs of others which can't be found because the script will generate
> them later. How can I make an orderer sql dump???

A quick fix would be to just restore the dump multiple times -
everything which already exists will be skipped, the rest will be
loaded. Repeat until everything is fine. ;-)

Hope that helps,

Tino.

--
„Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi)

www.craniosacralzentrum.de
www.forteego.de

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

Предыдущее
От: "Sergio Gabriel Rodriguez"
Дата:
Сообщение: pg_dump/pg_restore
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump/pg_restore