Owner of QSR, user postgres or qliksenserepository?

[gandalfgray]

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?

[Giuseppe_Novello]

What version of Qlik Sense do you have install? 

BR

Gio

[Anonymous · Accepted solution]

postgres <---  wrong

correct --> qliksenserepository  

Thanks, Gio!!

[gandalfgray]

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