Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
I am wondering if there has been some change in the way QSR should be owned?
We have an existing Production site which has been around for +2 years.
There the QSR database is owned by user postgres.
Also a lot of existing help/manual pages assumes that postgres owns QSR, ie https://support.qlik.com/articles/Basic/Migrating-Qlik-Sense-September-2017-November-2017-February-2...
However in https://help.qlik.com/en-US/sense/November2018/Subsystems/PlanningQlikSenseDeployments/Content/Sense...
the script to create the databases creates postgres with qliksenserepository as owner.
So my question is, should QSR be owned by postgres or by qliksenserepository?
postgres <--- wrong
correct --> qliksenserepository
View solution in original post
What version of Qlik Sense do you have install?
After starting this thread I saw the note on installation that you should not use postgres user as QSR database owner,
I guess this has been changed.
We started on 2.04, then upgraded to 3.0.1 etc etc, and are now at Nov 2018.
I am not sure, but I think when we upgraded from synched to shared persistance the QSR owner was automatically set to postgres