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. Do not forget to configure the pg_hba.conf file, which controls the database access.
   
   

   Code Block
   $ createuser -SDRP belladati_dbuser

   
   
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 -O belladati_dbuser belladati_db

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

...