diff options
| author | Klaus Weidenbach <Klaus.Weidenbach@gmx.net> | 2017-05-05 23:13:54 +0200 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2017-05-07 15:09:53 +0200 |
| commit | b7df4de4b751203f43ccf73ca88a2ac3b6c39729 (patch) | |
| tree | 3077e38fcd1aa4aa6403b753e7b22a951d3fafed /tests/travis/prepare_pgsql.sh | |
| parent | b237425c9465dad8c0f597f3402d8119d40d1b2e (diff) | |
| download | volse-hubzilla-b7df4de4b751203f43ccf73ca88a2ac3b6c39729.tar.gz volse-hubzilla-b7df4de4b751203f43ccf73ca88a2ac3b6c39729.tar.bz2 volse-hubzilla-b7df4de4b751203f43ccf73ca88a2ac3b6c39729.zip | |
:construction_worker::white_check_mark::bug: Import table structure in TravisCI.
Fix a syntax error in schema_postres.sql which was discovered while
working on this.
Diffstat (limited to 'tests/travis/prepare_pgsql.sh')
| -rwxr-xr-x | tests/travis/prepare_pgsql.sh | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/tests/travis/prepare_pgsql.sh b/tests/travis/prepare_pgsql.sh index dcd83f3be..63c7388cb 100755 --- a/tests/travis/prepare_pgsql.sh +++ b/tests/travis/prepare_pgsql.sh @@ -30,8 +30,15 @@ echo "Preparing for PostgreSQL ..." # Print out some PostgreSQL information psql --version # Why does this hang further execution of the job? -psql -c "SELECT VERSION();" -U postgres +psql -U postgres -c "SELECT VERSION();" # Create Hubzilla database -psql -c "DROP DATABASE IF EXISTS hubzilla;" -U postgres -psql -c "CREATE DATABASE hubzilla;" -U postgres +psql -U postgres -c "DROP DATABASE IF EXISTS hubzilla;" +psql -U postgres -c "CREATE DATABASE hubzilla;" + +# Import table structure +psql -U postgres -v ON_ERROR_STOP=1 hubzilla < ./install/schema_postgres.sql + +# Show databases and tables +psql -U postgres -l +psql -U postgres -d hubzilla -c "\dt;" |