I just barely did this yesterday on Qlik Sense 3.1; it totally works. Like @Michael instructed, I used pgAdmin3, but I used the Repository Db Superuser Password from the installation process to connect. And, yes, you absolutely must bounce the Windows services for Qlik Sense (since the Central Proxy has to be restarted, and you can't get into the QMC yet).
Though, in my case, after bouncing the Repository Database (because it makes all the other services bounce too), many of the Qlik Sense services failed to restart automatically, so I had to manually start them; watch for that. Once that was done, I got into the QMC just fine. (And then I immediately change the default Virtual Proxy's "Windows authentication pattern" setting to "Forms", because I also hate Http Basic Authentication's inability to logout without closing down the browser.)
Now that I know how to do this, I find it easier than having to remember to stop the IIS website instance that's using ports 80 and 443 before I start the Qlik Sense installation. I'm also glad that I have a clean install of Windows, because Qlik Sense uses a ton of ports. I'm a little nervous that at some point, I'm going to have once again use netstat to manually confirm that there's no port conflicts for other services while troubleshooting a problem. E.g.: netstat -a -b -n -o | find "4242"
Michael, Good morning!
First of all pleasure, my name is Luiz Fernando and I am now joining the Qliksense universe.
I've seen a comment from you about QlikSense authentication for the http and https communication ports.
In my organization, we are not allowed to release port 80 and 8080, so I have the alternative to install the certificate and make the communication through port 443, configured in the correct QMC?
Is there any instruction for installing the certificate and configuration, which needs to follow a sequence?
I want to be sure that I'm doing the right thing for setting up the environment.
Thank you so much
Hello Luiz - sorry for the delay - I was on vacation - you are correct - you can find that information here:
Trust this will guide you in the right direction.
Stay well :-)
Thanks for the feedback, I apologize for bothering you on your vacation.
Then my understanding was correct.
Thank you for reinforcing my thinking. I'm really enjoying this world of Qlik Sense, still adapting.
Thank you very much
Hi @Mike. What if there is no pg admin.exe in the specified path. (C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin\pgAdmin3.exe) . Is there anything that is missed out during installation.