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 11:46]
urbanl [Instalation and software configuration] 		tutorial:adm:server_preparation_tmp [2020/03/11 08:22]
urbanl [PostgreSQL]
Line 60: Line 60:
 ===== PostgreSQL ===== ===== PostgreSQL =====
 <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 CentOS7(versions can vary):+
 <code bash> <code bash>
-# add repository +# enable module postgres 12 
-yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm +yum module enable postgresql:12 
-# disable centos8 build-in module +yum install -y postgresql-server postgresql-contrib postgresql-libs
-yum module disable postgresql +
-# install postgresql components +
-yum install -y postgresql11-server postgresql11-contrib pgstat2_11 pg_top11  postgresql11-libs+
 </code> </code>
  
   * 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/
 chmod 700 /data/pgsql chmod 700 /data/pgsql
 </code> </code>
 +
   * 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>