Re: Programmatically duplicating a schema

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Programmatically duplicating a schema
Дата
Msg-id CAKFQuwaSR16WMTn+MB-eh30LmeJ9gpFU8iqztCJhffv=DCrydw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Programmatically duplicating a schema  (matt.figg@internode.on.net)
Список pgsql-general
On Mon, Mar 12, 2018 at 11:05 PM, <matt.figg@internode.on.net> wrote:

The reason we'd want to infer the create statements via pg_dump is, so we don't need to keep database migration files in sync with a 'create new schema' SQL script.  It adds risk that they get out of sync, causing inconsistencies in new schemas created by the library.

​Then don't have a "create new schema" script (aside from the very first one) run your migrations even when creating new installations.

​David J.

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: UPSERT on a view
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question on corruption (PostgreSQL 9.6.1)