I thought I would try sqitch and your setup. From the sqitch tutorial $ sqitch init firstsqitch --uri github.com/USERNAME/firstsqitch/ --engine pg
Then your alter $ sqitch engine alter pg --top-dir sql Missing Engine "pg"; use "add pg db:pg:" to add it
Thought I try $ sqitch engine add pg --top-dir sql Created sql/ Created sql/sqitch.plan Created sql/deploy/ Created sql/revert/ Created sql/verify/
It added 3 lines to sqitch.conf $ cat sqitch.conf [core] engine = pg # plan_file = sqitch.plan # top_dir = .
# target = db:pg: # registry = sqitch # client = psql
[engine "pg"] target = db:pg: top_dir = sql
Forward I go.
On my second try with project, I put the top_dir declaration on 'sqitch init' command
sqitch init secondsqitch --uri github.com/jimeUWOSH/secondsqitch/ --engine pg --top-dir sql
my repo has notes for the OS and DB user
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I thought I would try sqitch and your setup.
From the sqitch tutorial
$ sqitch init firstsqitch --uri github.com/USERNAME/firstsqitch/ --engine pg
Then your alter
$ sqitch engine alter pg --top-dir sql
Missing Engine "pg"; use "add pg db:pg:" to add it
Thought I try
$ sqitch engine add pg --top-dir sql
Created sql/
Created sql/sqitch.plan
Created sql/deploy/
Created sql/revert/
Created sql/verify/
It added 3 lines to sqitch.conf
$ cat sqitch.conf
[core]
engine = pg
# plan_file = sqitch.plan
# top_dir = .
[engine "pg"]
[engine "pg"]
target = db:pg:
top_dir = sql
Forward I go.
On my second try with project, I put the top_dir declaration on 'sqitch init' command
sqitch init secondsqitch --uri github.com/jimeUWOSH/secondsqitch/ --engine pg --top-dir sql
my repo has notes for the OS and DB user