Boda Lite: How to install PosgreSQL Database

You can use Boda-Lite without loading data into a database, but in this case you will miss out on a lot of features already available, and also new features in near future.

In order to improve your experience with Boda-Lite, we recommend installation of PostgreSQL database so that the tool can do further analysis on your data. As PostgresSQL requires elevated privileges to be run as a service, you need to manually install it.

Steps to install PostgreSQL database

1. Download latest version

Download latest version (version 10.9 is recommened ) installer from the Enterprise DB Download page

2. Run Installation

Click the installer to start the installation and follow default installation steps

Install Microsof C++
image
image

Setup PostgreSQL
image

Installation Directory
image

Select Components
image

Data Directory
image

Password

IMPORTANT
The database will have a superuser:

postgres

Here you can define the password you’re going to use later, when setting up the database.

Choose the password you want. We suggest:

boda

image

Port
image

Advanced Options
image

Pre Installation Summary
image

Ready to Install
image

Installing
image

Completing the PostgreSQL Wizard
image

After you click Finish, a new Window appear…

image

Close it - setup will be done via Boda Lite interface.

3. Setup Database

Now, to finish, you need to setup database.

Restart Boda Lite.

3.1 In the System tab, click Settings.
image

3.2 And in Setting tab, click Database.
image

3.3 In Database tab, fill the Password with the one filled during Installation.
image

3.4 No you’re done.

Just some more few clicks…

3.4.1 Click Update button: to save new credential info
image

3.4.2 Click click Setup database button. This will create the application database (boda), user(bodastage) with password (password) and also create other database objects such as tables.
image

3.4.3 Click Test Connection button: to confirm everything is fine.
image

If everything is fine, you should see the message: Connected successfully to server.
image

Troubleshooting

If database is not OK you can visit troubleshooting page:

Troubleshooting Boda Lite

Resources