Re: Restoring a postgres database

Поиск
Список
Период
Сортировка
От Dennis Björklund
Тема Re: Restoring a postgres database
Дата
Msg-id Pine.LNX.4.44.0307090912550.1516-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: Restoring a postgres database  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Restoring a postgres database  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On Wed, 9 Jul 2003, Tom Lane wrote:

> > schema dump searching for dependancies. You can then use tsort to dump out
> > the order that things should be restored in.
>
> Now that we have dependency tracking on the server side (see pg_depend)
> this should be just a small matter of programming.  No one's tackled it
> yet though.

It's not enough to just order things. To get something that always works
one need code that can break up cycles in the graph. With alter table and
other constructs it's easy to create objects that depend on each other.

--
/Dennis


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

Предыдущее
От: "Maksim Likharev"
Дата:
Сообщение: Re: Statistics on a table
Следующее
От: mixo
Дата:
Сообщение: Re: Benchmarking