Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
tutorial:adm:server_preparation_tmp [2020/03/10 15:08]
urbanl [TODO] 		tutorial:adm:server_preparation_tmp [2020/03/11 08:23]
urbanl [PostgreSQL]
Line 58: Line 58:
 screen dnsutils sysstat lsof haveged nmap tcpdump traceroute tcptraceroute curl iptables-persistent screen dnsutils sysstat lsof haveged nmap tcpdump traceroute tcptraceroute curl iptables-persistent
 </code> </code>
-===== PostgreSQL =====+===== PostgreSQL -!CHANGED =====
 <note tip>If you are install CzechIdM on Sql server, please follow [[tutorial:adm:mssql_database_support|this tutorial]].</note> <note tip>If you are install CzechIdM on Sql server, please follow [[tutorial:adm:mssql_database_support|this tutorial]].</note>
-CentOS7 default repository version of PostgreSQL is 9.2 but IdM not support that version. In our tutorial, we will install newer version 9.6. Moreover, we install database data into /data not /var/lib which is the default option.+CentOS8 default repository version of PostgreSQL is 10 but IdM not support that version. In our tutorial, we will install newer version 12. Moreover, we install database data into /data not /var/lib which is the default option.
 ==== Database server installation - CentOS7 and CentOS8 -!CHANGED ==== ==== Database server installation - CentOS7 and CentOS8 -!CHANGED ====
   * Software installation on CentOS7(versions can vary):   * Software installation on CentOS7(versions can vary):
Line 67: Line 67:
 yum install -y postgresql96-server postgresql96-contrib pgstat2_96 pg_top96  postgresql96-libs yum install -y postgresql96-server postgresql96-contrib pgstat2_96 pg_top96  postgresql96-libs
 </code> </code>
-#TODO 
   * Software installation on CentOS8(versions can vary):   * Software installation on CentOS8(versions can vary):
 +
 <code bash> <code bash>
 # enable module postgres 12 # enable module postgres 12
Line 77: Line 77:
   * create new system directory:   * create new system directory:
  
-<code>+<code bash>
 mkdir -p /data/pgsql/11/data/ mkdir -p /data/pgsql/11/data/
 chown -R postgres:postgres /data/pgsql/ chown -R postgres:postgres /data/pgsql/
Line 84: Line 84:
  
   * Copy of the configuration file for systemd, in which we will make change of directory for data:   * Copy of the configuration file for systemd, in which we will make change of directory for data:
 +
 <code bash> <code bash>
 cp /usr/lib/systemd/system/postgresql-11.service /etc/systemd/system/ cp /usr/lib/systemd/system/postgresql-11.service /etc/systemd/system/
 </code> </code>
 +
 In the file ''/etc/systemd/system/postgresql-11.service'' change the directory for data as follows: In the file ''/etc/systemd/system/postgresql-11.service'' change the directory for data as follows:
 <code> <code>