Note : scripts assume web server's user used to access to the database is www.

If it is different ... modify the script.

1. cd ${GEPPETTO_HOME}/Server/Sql
2. connect to your database with a user that has enough rights to create a schema and other objects
3. launch the script postgresql.sql

Notez-bien : this script assumes the web server use user 'www' to access to the DB.

As example :

laurent@chose:~/projets/Geppetto/Server/Sql$ psql www
psql (8.4.7)
Saisissez « help » pour l'aide.

www=> i postgresql.sql
Drop potential existing environment
-----------------------------------
psql:postgresql.sql:13: NOTICE:  DROP cascade sur table geppetto.users
DROP SCHEMA
Create the schema
-----------------
CREATE SCHEMA
GRANT
...