Re: RFC tool to support development / operations work with slony replicated databases

Поиск
Список
Период
Сортировка
От Kenneth Downs
Тема Re: RFC tool to support development / operations work with slony replicated databases
Дата
Msg-id 45ED702B.5040105@secdat.com
обсуждение исходный текст
Ответ на RFC tool to support development / operations work with slony replicated databases  ("Andrew Hammond" <andrew.george.hammond@gmail.com>)
Ответы Re: RFC tool to support development / operations work with slony replicated databases
Список pgsql-general
Andrew Hammond wrote:
> Each release will include a directory that has the same name as the
> full release tag. This directory must contain all the scripts to be
> applied.

Have you considered using a data dictionary instead, so that you can
simply diff the structures and generate DDL to bring a database to its
current state?

If your scripts contain data modification code, they can be preserved,
but using a dictionary smooths over a lot of the quirkiness of the
scripts-based approach.


--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
Office: 631-689-7200   Cell: 631-379-0010

::Think you may have a problem with programming? Ask yourself this
::question: do you worry about how to throw away a garbage can?


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

Предыдущее
От: "senges"
Дата:
Сообщение: Re: Re : Re : COPY form stdin and file
Следующее
От: Kenneth Downs
Дата:
Сообщение: Re: M:M table conditional delete for parents