Changing the Default PostgreSQL Database Password

By default, the connection uses the username insight and password insight. You may want to change this password as an additional security measure.
  1. To change the password for the Xpress Insight user, start the PostgreSQL database console by opening a command window and entering the following: %XPRESSDIR%\insight\db\pgsql\bin\psql insightdb insight
  2. Enter the command ALTER ROLE to change the password. For example, to set the password to ficoxpress enter: ALTER ROLE insight WITH PASSWORD ficoxpress;
  3. Exit the PostgreSQL database console by entering: \q
  4. Update the data source with the new password. Open the file <installdir>\insight\server\wildfly-15.0.1.Final\standalone\configuration\standalone.xml in a text editor and locate the definition of the insightdb data source, which should look similar to the following: 
    <xa-datasource jndi-name="java:/com.fico.xpress.insight.db" pool-name="com.fico.xpress.insight.db" enabled="true" use-ccm="false" statistics-enabled="true">
                    <xa-datasource-property name="ServerName">localhost</xa-datasource-property>
                    <xa-datasource-property name="PortNumber">5432</xa-datasource-property>
                    <xa-datasource-property name="DatabaseName">insightdb</xa-datasource-property>
                    <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
                    <driver>postgresql</driver>
                    <xa-pool>
                        <min-pool-size>96</min-pool-size>
                        <max-pool-size>384</max-pool-size>
                        <interleaving>false</interleaving>
                        <pad-xid>false</pad-xid>
                        <wrap-xa-resource>false</wrap-xa-resource>
                    </xa-pool>
                    <security>
                        <user-name>insight</user-name>
                        <password>insight</password>
                    </security>
  5. Change the security section of the data-source definition to include the new password. For example: 
          <security>
         <user-name>insight</user-name>
         <password>ficoxpress</password>
      </security>
    Important The database local connections must be set to md5 in order for this password challenge to be effective. For more see Securing the PostgreSQL Database.
    Note If you secure the password for com.fico.xpress.insight.db, you should also update the credentials for com.fico.xpress.insight.mirrordb and com.fico.xpress.insight.dmndb.
  6. Save this file and restart the Xpress Insight Server to apply the new configuration.
Parent Topic Securing the PostgreSQL Database Password