Mercurial > p > roundup > code
diff .github/workflows/ci-test.yml @ 7721:d55427443443
chore: fix ci yaml formatting.
Travis failed with:
The command "psql -c "CREATE ROLE rounduptest_schema LOGIN PASSWORD
'rounduptest';" -U postgres - psql -c "CREATE DATABASE
rounduptest_schema;GRANT CREATE ON DATABASE rounduptest_schema TO
rounduptest_schema;" -U postgres" failed and exited with 2 during .
Looks like there was a third leading space that casued two lines to
get joined.
Github failed with:
ERROR: CREATE DATABASE cannot run inside a transaction block
The create db and grant command when run together worked for me. Maybe
a db difference? Split the two commands into separate psql calls.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Wed, 27 Dec 2023 23:05:16 -0500 |
| parents | 3071db43bfb6 |
| children | edd93fa4a5ec |
line wrap: on
line diff
--- a/.github/workflows/ci-test.yml Wed Dec 27 23:04:33 2023 -0500 +++ b/.github/workflows/ci-test.yml Wed Dec 27 23:05:16 2023 -0500 @@ -154,7 +154,8 @@ # set up postgresql database sudo -u postgres psql -c "CREATE ROLE rounduptest WITH CREATEDB LOGIN PASSWORD 'rounduptest';" -U postgres sudo -u postgres psql -c "CREATE ROLE rounduptest_schema LOGIN PASSWORD 'rounduptest';" -U postgres - sudo -u postgres psql -c "CREATE DATABASE rounduptest_schema;GRANT CREATE ON DATABASE rounduptest_schema TO rounduptest_schema;" -U postgres + sudo -u postgres psql -c "CREATE DATABASE rounduptest_schema;" -U postgres + sudo -u postgres psql -c "GRANT CREATE ON DATABASE rounduptest_schema TO rounduptest_schema;" -U postgres - name: install redis run: |