modules/tm351_modules/files/root/postgresql.setup

   1 #!/bin/bash -e
   2
   3 sudo su - postgres <<EOF
   4
   5 createdb tm351test
   6
   7 psql -q -c "CREATE USER test PASSWORD 'test';" tm351test
   8 psql -q -c "GRANT ALL PRIVILEGES ON DATABASE tm351test TO test;" tm351test
   9
  10 psql -q -c "CREATE USER test1 PASSWORD 'test1';" tm351test
  11 psql -q -c "GRANT ALL PRIVILEGES ON DATABASE tm351test TO test1;" tm351test
  12
  13 psql -q -c "CREATE USER test2 PASSWORD 'test2';" tm351test
  14 psql -q -c "GRANT ALL PRIVILEGES ON DATABASE tm351test TO test2;" tm351test
  15
  16 psql -q -c "CREATE USER logme PASSWORD 'logme';" tm351test
  17 psql -q -c "GRANT ALL PRIVILEGES ON DATABASE tm351test TO logme;" tm351test
  18 psql -q -c "ALTER USER logme SET log_statement='all';" tm351test
  19
  20 EOF
  21
  22 touch /root/postgresql.done