Setup BellaDati with PostgreSQL

These instructions will help you connect BellaDati to a PostgreSQL 8.4+ database.

1. Before You Begin

Are You Migrating BellaDati to Another Server?

If you are migrating BellaDati to another server, create an export of your data as an XML backup. You will then be able to transfer data from your old database to your new database.

On this page:

2. Create and Configure the PostgreSQL Database

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.
```
$ createuser -SDRP belladati 
```
Create a database for BellaDati to be used as data warehouse (e.g. belladati_db) with Unicode collation.
```
CREATE DATABASE belladati_db WITH ENCODING 'UNICODE';
```
Or from the command-line:
```
$ createdb -E UNICODE belladati_db
```
Ensure that the user has permissions to connect to the database, and to create and write to tables in the database.

Remember this database name, as it will be used to configure BellaDati's connection to this database in subsequent steps.

3. Copy the PostgreSQL JDBC Driver to Your Application Server (BellaDati WAR Only)

Skip this step if you are using BellaDati virtual applicance distribution. BellaDati virtual appliance includes the PostgreSQL JDBC driver.

Download the PostgreSQL JDBC driver from http://jdbc.postgresql.org/download.html. (Obtain version 9.0 of the JDBC 4 driver.)
Add the PostgreSQL JDBC driver jar to the lib/ directory of your application server.

4. Next steps

Continue configuring BellaDati WAR for your application server as described on:

Page tree