Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
gandalfgray
Valued Contributor II

Owner of QSR, user postgres or qliksenserepository?

Hi

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?

Labels (1)
1 Solution

Accepted Solutions
Support
Support

Re: Owner of QSR, user postgres or qliksenserepository?

postgres <---  wrong

 

correct --> qliksenserepository  

 

Thanks, Gio!!

View solution in original post

3 Replies

Re: Owner of QSR, user postgres or qliksenserepository?

What version of Qlik Sense do you have install? 

 

BR

 

Gio

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
Support
Support

Re: Owner of QSR, user postgres or qliksenserepository?

postgres <---  wrong

 

correct --> qliksenserepository  

 

Thanks, Gio!!

View solution in original post

gandalfgray
Valued Contributor II

Re: Owner of QSR, user postgres or qliksenserepository?

Thanks guys!

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