====== How to set a PostgreSQL as a primary DB instead of H2  ======

This tutorial is intended for those, who followed "[[:getting-started|Getting started]]" tutorial to run IdM as a local demo (for Linux server).
<note important>It is not recommended for production use!!!</note>

===== Prerequisities ===== 
1) Authentication method properly set in "pg_hba.conf" to be able to CzechIdM to connect.

[[tutorial:adm:server_preparation#database_server_configuration_and_sizing|example]]

2) DB dedicated to CzechIdM with proper owner - ideally named "czechidm"

 [[tutorial:adm:czechidm_installation#create_db_user_and_database_in_postgresql|example]]

3) PostgreSql up and running - check with
<code>
systemctl status postgresql.service -l
</code>
===== How to =====
1) [[https://jdbc.postgresql.org/download/postgresql-42.2.14.jar|Download]] jdbs postgresql driver for tomcat and place it into tomcat /lib

[[tutorial:adm:czechidm_installation#jdbc_driver_installation_%E2%80%8B-_centos8_%E2%80%8B|example]]

2) In tomcat /bin create "setenv.sh" file with 
<code>
JAVA_OPTS="$JAVA_OPTS -Djava.awt.headless=true -Djava.security.egd=file:/dev/./urandom -Dorg.apache.tomcat.util.buf.UDecoder.ALLOW_ENCODED_SLASH=true -Djavax.servlet.request.encoding=UTF-8 -Dspring.profiles.active=dev -Djava.util.Arrays.useLegacyMergeSort=true"
</code>

thus you specify spring profile as "dev"

3) Check file "/webapps/idm/WEB-INF/classes/application-dev.properties" in tomcat. There credentials must be set for the tomcat to connect to PostgreSQL, for example

<code>
spring.datasource.url=jdbc:postgresql://localhost:5432/czechidm
spring.datasource.username=czechidm
spring.datasource.password=TODOPASSWORD
</code>

If idm wasn't deployed yet (folder idm doesn't exist). The file *application-dev.properties* will be available in idm.war file. "idm.war/webapps/idm/WEB-INF/classes/application-dev.properties".

4) Now you can start tomcat as usual (startup.sh)

<note important>Be aware that this tutorial only shows quick solution to set connection to postgreSQL. It is for testing purposes only and not for production use</note>
<note important>If you upgrade to new version of czechidm - thus tomcat make changes in "webapps/idm" directory, you lost the configuraction set in this tutorial. So do not deploy to tomcat unless you backup files mensioned in this tutorial!</note>

<note tip>For files catalina.sh, catalina.sh, catalina.sh and catalina.sh must be setup permissions for read and execute for user that will execute commands for startup and end  tomcat - IdM application.</note>