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:server_preparation_tmp [2020/07/24 08:19] fiserp [Database server installation - CentOS8] |
tutorial:adm:server_preparation_tmp [2020/07/24 08:29] fiserp [DB server configuration] |
||
---|---|---|---|
Line 47: | Line 47: | ||
===== PostgreSQL | ===== PostgreSQL | ||
<note tip>If you are installing CzechIdM on Microsoft SQL Server, please follow [[tutorial: | <note tip>If you are installing CzechIdM on Microsoft SQL Server, please follow [[tutorial: | ||
- | We install PostgreSQL 12 database binaries and set database data directory | + | We install PostgreSQL 12 database binaries and change |
==== Database server installation - CentOS8 ==== | ==== Database server installation - CentOS8 ==== | ||
* Software installation on CentOS8(versions can vary): | * Software installation on CentOS8(versions can vary): | ||
Line 144: | Line 144: | ||
==== DB server configuration ==== | ==== DB server configuration ==== | ||
- | First of all, enable | + | * Enable |
In the file ''/ | In the file ''/ | ||
Line 151: | Line 151: | ||
host all | host all | ||
</ | </ | ||
- | + | and change the value at the end of each line to '' | |
- | and change the value at the end of each line into md5 like this: | + | |
< | < | ||
host all | host all | ||
Line 158: | Line 157: | ||
</ | </ | ||
- | Now we can do DB sizing. | + | * Adjust |
+ | * In following snippet, we presume the system has 3GB of memory | ||
+ | * We also log queries running longer than 200ms. | ||
In a file ''/ | In a file ''/ | ||
< | < |