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.
4. Check if your database has the plpgsql language, if not, you can define it using this command:
   
   

   Code Block
   CREATE LANGUAGE plpgsql

   Or from the command-line:
   
   

   Code Block
   $ createlang -U belladati_dbuser plpgsql belladati_db

   
   

createlang -h 127.0.0.1 -U belladati_dbuser plpgsql belladati_db

...