Talk:Installation en

From MapbenderWiki

Tried to set up Mapbender database with proper rights. I created a superuser "ich" for myself who installed Mapbender, and a user "mapbender" who just has LOGIN privileges. But somehow this doesn't work. If you know how to set it up, let me know. --Christoph Baudson 13:33, 25 July 2008 (CEST)

ich:~$ su postgres
postgres:~$ psql 

postgres=# CREATE ROLE ich PASSWORD 'thepassword' CREATEDB CREATEROLE LOGIN SUPERUSER;
postgres=# \q 

postgres:~$ exit

ich:~$ createdb -E UTF8 <dbname>
ich:~$ psql -f workspace/dev/resources/db/postgresql/pgsql_schema.sql <dbname>
ich:~$ psql -f workspace/dev/resources/db/postgresql/utf8/pgsql_data.sql <dbname>
ich:~$ psql -f workspace/dev/resources/db/postgresql/pgsql_serial_set_sequences.sql <dbname>

ich:~$ psql -d <dbname>

<dbname>=# CREATE ROLE mapbender LOGIN;
<dbname>=# GRANT ALL ON DATABASE <dbname> TO mapbender;