Page History
...
- 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 thepg_hba.conf
file, which controls the database access.Code Block $ createuser -SDRP belladati_dbuser
- Create a database for BellaDati to be used as data warehouse (e.g.
belladati_db
) with Unicode collation.
Or from the command-line:Code Block CREATE DATABASE belladati_db WITH ENCODING 'UNICODE';
Code Block $ createdb -E UNICODE -O belladati_dbuser belladati_db
- Ensure that the user has permissions to connect to the database, and to create and write to tables in the database.
- Check if your database has the plpgsql language, if not, you can define it using this command:
Or from the command-line:Code Block CREATE LANGUAGE plpgsql
Code Block $ createlang -U belladati_dbuser plpgsql belladati_db
Info |
---|
Remember this database name, as it will be used to configure BellaDati's connection to this database in subsequent steps. |
...
Overview
Content Tools