diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-02-07 09:03:49 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-02-07 09:03:49 +0100 |
| commit | 91dda86a74e5e4f4d474c84b037209315230a0b3 (patch) | |
| tree | 9b10c7c316761bc03dd4917a4240c86d4da76434 /tests/travis/prepare_pgsql.sh | |
| parent | 4171854e2fdcf30592025cc67815e032ea97fc06 (diff) | |
| parent | 24a650d7ecc07e46a7d7cfb1ef3cd60cc7da791b (diff) | |
| download | volse-hubzilla-91dda86a74e5e4f4d474c84b037209315230a0b3.tar.gz volse-hubzilla-91dda86a74e5e4f4d474c84b037209315230a0b3.tar.bz2 volse-hubzilla-91dda86a74e5e4f4d474c84b037209315230a0b3.zip | |
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into dev
Diffstat (limited to 'tests/travis/prepare_pgsql.sh')
| -rwxr-xr-x | tests/travis/prepare_pgsql.sh | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/tests/travis/prepare_pgsql.sh b/tests/travis/prepare_pgsql.sh index 63c7388cb..0175b9858 100755 --- a/tests/travis/prepare_pgsql.sh +++ b/tests/travis/prepare_pgsql.sh @@ -33,12 +33,17 @@ psql --version psql -U postgres -c "SELECT VERSION();" # Create Hubzilla database -psql -U postgres -c "DROP DATABASE IF EXISTS hubzilla;" -psql -U postgres -c "CREATE DATABASE hubzilla;" +psql -U postgres -c "DROP DATABASE IF EXISTS travis_hubzilla;" +psql -U postgres -v ON_ERROR_STOP=1 <<-EOSQL + CREATE USER travis_hz WITH PASSWORD 'hubzilla'; + CREATE DATABASE travis_hubzilla; + ALTER DATABASE travis_hubzilla OWNER TO travis_hz; + GRANT ALL PRIVILEGES ON DATABASE travis_hubzilla TO travis_hz; +EOSQL # Import table structure -psql -U postgres -v ON_ERROR_STOP=1 hubzilla < ./install/schema_postgres.sql +psql -U travis_hz -v ON_ERROR_STOP=1 travis_hubzilla < ./install/schema_postgres.sql # Show databases and tables psql -U postgres -l -psql -U postgres -d hubzilla -c "\dt;" +psql -U postgres -d travis_hubzilla -c "\dt;" |