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/04/21 11:43] fiserp [Create DB user and database in PostgreSQL] |
tutorial:adm:czechidm_installation_win [2020/04/21 11:51] fiserp [Create DB user and database in PostgreSQL] |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| ==== Create DB user and database in PostgreSQL ==== | ==== Create DB user and database in PostgreSQL ==== | ||
| - | 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 (for the OpenSCG PostgreSQL) or fire-up the cmd terminal and run '' |
| <code sql> | <code sql> | ||
| CREATE USER czechidm PASSWORD ' | CREATE USER czechidm PASSWORD ' | ||
| - | # Choose appropriate collation and create database. | + | -- Choose appropriate collation and create database. |
| - | # with english collation (we expect the default windows installation with cp1250/ | + | -- with english collation (we expect the default windows installation with cp1250/ |
| CREATE DATABASE " | CREATE DATABASE " | ||
| - | # with czech collation | + | -- with czech collation |
| CREATE DATABASE " | CREATE DATABASE " | ||
| </ | </ | ||