Preparing the Database

You have to create a new UTF-8 encoded PostgreSQL database, which will be used with the application. You may use a sample SQL script:

-- BE SURE TO USE A REAL PASSWORD!
CREATE ROLE fs_wl WITH LOGIN PASSWORD 'test_password' SUPERUSER;

-- SET LC_COLLATE AND LC_CTYPE SUITABLE FOR YOUR LANGUAGE
CREATE DATABASE fs_wl
  WITH OWNER = fs_wl
       ENCODING = 'UTF8'
       LC_COLLATE = 'en_US.UTF-8'
       LC_CTYPE = 'en_US.UTF-8'
       CONNECTION LIMIT = -1;

This script is just an example - please ensure to set a real password for your user. Note that user should be created with SUPERUSER parameter due to installation of required postgresql extensions.

Next

Setup App