Re: Open Source tool to deploy/promote PostgreSQL DDL

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Open Source tool to deploy/promote PostgreSQL DDL
Дата
Msg-id 3ddb7a3c-66a7-5063-ce5b-ebb549577f2a@gmail.com
обсуждение исходный текст
Ответ на Re: Open Source tool to deploy/promote PostgreSQL DDL  (Ravi Krishna <sravikrishna3@gmail.com>)
Список pgsql-general
On 07/11/2018 03:39 PM, Ravi Krishna wrote:
>> Where I work, the requirement to have rollback scripts is part of the ITIL requirement for Changes to have a backout
procedure.
>>
> Liquibase provides that ability, but IMO rollback for RDBMS is always bit tricky.  Certain DDL operations can take
longtime if it involves
 
> a table rewrite.  PG is actually better than others.

Yeah, that's true.  Sometimes I just dump the whole table, and reload if a 
rollback is necessary.



-- 
Angular momentum makes the world go 'round.


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

Предыдущее
От: Ravi Krishna
Дата:
Сообщение: Re: Open Source tool to deploy/promote PostgreSQL DDL
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: timestamp (military) at time zone without the suffix