Postgres

This section briefs on how to configure Fluwiz and connect to database.

Database Setup

Postgres

Connect to the database and create database schema - palmyra, demo

create schema palmyra create schema demo

Run the scripts available under setup/database/postgres folder. Run the scripts in the below order

1. palmyra_schema.sql
2. palmyra_data.sql
3. demo_data.sql

Connect to database

After the database schema is successfully created, Configure the connection parameters in the property file

resources/database/myapp.properties

db.server=127.0.0.1
db.port=5432
db.user=postgres
db.password=secretkey
db.database=postgres
db.schema=palmyra
db.addl.schema=demo


# Do not modify the below settings
db.type=postgresql
db.driver=org.postgresql.Driver
db.poolMaxSize=25
db.poolMinIdle=10
db.poolMaxIdle=20
db.poolInitialSize=5

Now the database setup is complete. Restart the server to make the changes effective.