Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
tutorial:adm:czechidm_installation_win [2020/03/18 09:18] fiserp [Create CzechIdM configuration] |
tutorial:adm:czechidm_installation_win [2020/04/21 11:43] fiserp [Create DB user and database in PostgreSQL] |
||
---|---|---|---|
Line 10: | Line 10: | ||
Open a **PSQL** binary from the Start menu. A windows-cmd-like window should appear with a prompt. Create a db user and a database for CzechIdM. | Open a **PSQL** binary from the Start menu. A windows-cmd-like window should appear with a prompt. Create a db user and a database for CzechIdM. | ||
- | < | + | < |
CREATE USER czechidm PASSWORD ' | CREATE USER czechidm PASSWORD ' | ||
+ | |||
+ | # Choose appropriate collation and create database. | ||
+ | # with english collation (we expect the default windows installation with cp1250/ | ||
CREATE DATABASE " | CREATE DATABASE " | ||
+ | # with czech collation | ||
+ | CREATE DATABASE " | ||
</ | </ | ||