Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Tool_Tip
Creator III
Creator III

Something wrong ??

Dear Experts:

Reference :

https://community.qlik.com/t5/Official-Support-Articles/Postgres-database-moved-to-new-host-but-some...

 

After executing below PowerShell script, we are getting some warning messages even though we have provided in the script.

Please let us know if anything we are missing in the script or anything wrong:

 

# Set the Installation Directory for Qlik Sense
$installDir = 'C:\Program Files\Qlik\Sense\'
#change that to the new database server
$newdatabasehostname='localhost'
# Specify the new password for the qliksenserepository account
$password = 'qlik1234'
# Find all Configure-Service.ps1 scripts in the installation directory and execute them
$files = Get-ChildItem -Path $installDir -Include Configure-Service.ps1 -Recurse
foreach ($file in $files) {
$ScriptToRun=$($file.FullName)
&$ScriptToRun $newdatabasehostname 4432 qliksenserepository $password -postgresHome 'C:\Program Files\PostgreSQL\14'
}

 

Tool_Tip_0-1736415735577.png

 

Tool_Tip_1-1736415749405.png

 

Labels (1)
2 Replies
Sebastian_Linser

Hello, that is fully normal and working as designed. you skipped the parameter -superuser and -superuserpassword which you dont need if you are just changing the configure-service.ps1 script to change the hostname / port / qliksenserepository user password.

 

that one would still be postgresHome 'C:\Program Files\Qlik\Sense\PostgreSQL\14' ->'C:\Program Files\PostgreSQL\14' that folder only exist on the node where you just installed the standalone DB, but not on a Rim node. https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repo...

Step 16 and 17 under upgrade.

 

best regards

Sebastian

Help users find answers! Don't forget to mark a solution that worked for you! 🙂
Tool_Tip
Creator III
Creator III
Author

And the most interesting part here is after executing above ps script the Configure-Service.ps1 for  one of the service below did not changed the path.
C:\Program Files\Qlik\Sense\AppDistributionService

Tool_Tip_0-1736839566329.png