This page describes how to install a very basic PostgreSQL Server RDBMS installation with a basic database for Ubisecure CustomerID. Many details will vary on a per customer basis, so further tuning is left to the integrator. One significant detail is to manage the collation rules on a per-column basis, therefore it may be necessary to make changes to the provided Database Definition Language (DDL) files before they are used to create the database tables for Ubisecure CustomerID. Collations define how text is compared and sorted and whether searches should behave in a case sensitive or insensitive manner.
...
Ubisecure CustomerID is tested with PostgreSQL 9.46.x10.
PostgreSQL binaries and instructions on how to use platform specific package managers to download and install PostgreSQL, can be found at the following URL:
https://www.postgresql.org/download/
...
| Code Block | ||
|---|---|---|
| ||
cd /d C:\Program Files\PostgreSQL\9.46\bin (your PostgreSQL installation directory) psql --username=postgres -c "CREATE USER customerid_user WITH PASSWORD 'replace with your database.password from win32.config'" |
...
Now that there's a named collation, it can be attached to column definitions by modifying DDL like in example below:
Use the following command to open the cid_create.sql file and do the modifications accordingly.
| Code Block | ||
|---|---|---|
| ||
cd /d %PROGRAMFILES%\Ubisecure\customerid\sql\ notepad cid_create.sql |
...