Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread tirveni yadav
On Thu, Jul 12, 2018 at 5:18 AM, Adrian Klaver wrote: > On 07/11/2018 04:01 PM, Ron wrote: >> >> On 07/11/2018 04:10 PM, Christopher Browne wrote: >> [snip] >>> >>> ITIL surely does NOT specify the use of database rollback scripts as >>> THE SPECIFIED MECHANISM for a backout procedure. >>> >>> In

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Adrian Klaver
On 07/11/2018 04:01 PM, Ron wrote: On 07/11/2018 04:10 PM, Christopher Browne wrote: [snip] ITIL surely does NOT specify the use of database rollback scripts as THE SPECIFIED MECHANISM for a backout procedure. In practice, we tend to take database snapshots using filesystem tools, as that repre

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Ron
On 07/11/2018 04:10 PM, Christopher Browne wrote: [snip] ITIL surely does NOT specify the use of database rollback scripts as THE SPECIFIED MECHANISM for a backout procedure. In practice, we tend to take database snapshots using filesystem tools, as that represents a backout procedure that will

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Tim Cross
Gavin Flower writes: > On 11/07/18 11:04, Hustler DBA wrote: >> Thanks Adrian and Rich, >> I will propose sqitch to the client, but I think they want something >> with a GUI frontend. >> >> They want to deploy database changes, track which environments the >> change was deployed to, be able t

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Christopher Browne
On Wed, 11 Jul 2018 at 16:37, Ron wrote: > > On 07/11/2018 03:21 PM, Christopher Browne wrote: > > I have built one that I call Mahout > > (https://github.com/cbbrowne/mahout) which has the merit of involving > > just two shell scripts, one of which is an auditing tool (pgcmp). > > > > It implemen

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Ron
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 long t

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Ravi Krishna
> > 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 long time if it involves a table rewrite.

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Ron
On 07/11/2018 03:21 PM, Christopher Browne wrote: I have built one that I call Mahout (https://github.com/cbbrowne/mahout) which has the merit of involving just two shell scripts, one of which is an auditing tool (pgcmp). It implements a "little language" to indicate dependencies between the SQL

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Christopher Browne
I have built one that I call Mahout (https://github.com/cbbrowne/mahout) which has the merit of involving just two shell scripts, one of which is an auditing tool (pgcmp). It implements a "little language" to indicate dependencies between the SQL scripts that implement the DDL changes. The notabl

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Jeremy Finzel
On Tue, Jul 10, 2018 at 5:13 PM Hustler DBA wrote: > Hi Community, > A client of mine is looking for an open source tool to deploy and promote > PostgreSQL DDL changes through database environments as part of SDLC. What > tools (open source) does the community members use? I normally use scripts,

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Raymond O'Donnell
On 10/07/18 23:13, Hustler DBA wrote: Hi Community, A client of mine is looking for an open source tool to deploy and promote PostgreSQL DDL changes through database environments as part of SDLC. What tools (open source) does the community members use? I normally use scripts, but they want som

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-11 Thread Thomas Kellerer
Hustler DBA schrieb am 11.07.2018 um 00:13: > A client of mine is looking for an open source tool to > deploy and promote PostgreSQL DDL changes through database > environments as part of SDLC. What tools (open source) does the > community members use? I normally use scripts, but they want > someth

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-10 Thread Rob Sargent
On 07/10/2018 05:04 PM, Hustler DBA wrote: Thanks Adrian and Rich, I will propose sqitch to the client, but I think they want something with a GUI frontend. They want to deploy database changes, track which environments the change was deployed to, be able to rollback a change (with a rollb

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-10 Thread Gavin Flower
On 11/07/18 11:04, Hustler DBA wrote: Thanks Adrian and Rich, I will propose sqitch to the client, but I think they want something with a GUI frontend. They want to deploy database changes, track which environments the change was deployed to, be able to rollback a change (with a rollback scr

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-10 Thread Hustler DBA
Thanks Adrian and Rich, I will propose sqitch to the client, but I think they want something with a GUI frontend. They want to deploy database changes, track which environments the change was deployed to, be able to rollback a change (with a rollback script), track when and if the change was rolle

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-10 Thread Rich Shepard
On Tue, 10 Jul 2018, Hustler DBA wrote: A client of mine is looking for an open source tool to deploy and promote PostgreSQL DDL changes through database environments as part of SDLC. What tools (open source) does the community members use? I normally use scripts, but they want something open so

Re: Open Source tool to deploy/promote PostgreSQL DDL

2018-07-10 Thread Adrian Klaver
On 07/10/2018 03:13 PM, Hustler DBA wrote: Hi Community, A client of mine is looking for an open source tool to deploy and promote PostgreSQL DDL changes through database environments as part of SDLC. What tools (open source) does the community members use? I https://sqitch.org/ normally u