Page History

...

1. Create a database user which BellaDati will connect as (e.g. belladati_dbuser). Remember this database user name, as it will be used to configure BellaDati's connection to this database in subsequent steps.
   
   

   Code Block
   createdbcreateuser -E UNICODESDRP belladati_db

   
   
2. Create a database for BellaDati to be used as data warehouse (e.g. belladati_db) with Unicode collation.
   
   

   Code Block
   CREATE DATABASE belladati_db WITH ENCODING 'UNICODE';

   Or from the command-line:
   
   

   Code Block
   $ createdb -E UNICODE belladati_db

3. Ensure that the user has permissions to connect to the database, and to create and write to tables in the database.

...