sqitchers / sqitch

Sensible database change management
https://sqitch.org
MIT License
2.76k stars 214 forks source link

Sqitch not creating registy tables on first sqitch deploy postgres #562

Open Doziadele opened 3 years ago

Doziadele commented 3 years ago

Adding registry tables to db:pg:mydbname ERROR: syntax error at end of input LINE 1: SHOW ^ "psql" unexpectedly returned exit value 1

theory commented 3 years ago

Before it creates the registry, Sqitch uses SHOW server_version_num to determine the version it's deploying to:

https://github.com/sqitchers/sqitch/blob/9faa8421a7e9cf4545e07ce842b625f253ed3a62/lib/App/Sqitch/Engine/pg.pm#L208-L210

I can't see why that would be an issue; what version and build of Postgres are you deploying to?

theory commented 2 years ago

Did you ever get this issue resolved, @Doziadele?