Re: pg_dump/pg_restore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump/pg_restore
Дата
Msg-id 8490.1207690205@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump/pg_restore  ("Sergio Gabriel Rodriguez" <sgrodriguez@gmail.com>)
Список pgsql-admin
"Sergio Gabriel Rodriguez" <sgrodriguez@gmail.com> writes:
> 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???

Switch to a newer PG version.  If memory serves, 8.0 was the first
version in which pg_dump paid attention to dependencies rather than just
the order of original creation of views.  In 7.x it wasn't hard to
cause problems by doing CREATE OR REPLACE VIEW.

            regards, tom lane

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

Предыдущее
От: Tino Schwarze
Дата:
Сообщение: Re: pg_dump/pg_restore
Следующее
От: "Ashish Sharma"
Дата:
Сообщение: SQL fast in PSQL, very slow using MS.NET driver