Qlik Community

Qlik Sense Deployment & Management

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

Highlighted
Partner
Partner

Error Msg from PostgreSQL

Hi,

we do have some Warnings from the WindowsServer. The Warning comes from PostgreSQL.

skipping "pg_statistic" ---
only table or database owner can vacuum


how can we avoid the warning

Many thx

Christoph

7 Replies
MVP & Luminary
MVP & Luminary

Re: Error Msg from PostgreSQL

Partner
Partner

Re: Error Msg from PostgreSQL

It looks like that our User qliksenserepository has no roll - do weneed the roll 'superuser' for him?

2018-09-19_15h15_11.png

MVP & Luminary
MVP & Luminary

Re: Error Msg from PostgreSQL

Probably, but I have no idea how to do it in PostgreSQL. I think the specific Postgre forums are here more suitable as the qlik community.

- Marcus

Partner
Partner

Re: Error Msg from PostgreSQL

Hi Markus,

many thx - the postgeSQL database is the Qlik internal one. So i think this is the right place

MVP & Luminary
MVP & Luminary

Re: Error Msg from PostgreSQL

I didn't know that there is any PostgreSQL included in the Sense environment (seems that I'm not up to date anymore). But then I could imagine that there are similar logics like in QlikView in that way that the user who runs the services needs to be member of certain usergroups like QlikView Administrators and if I look on your screenshot there is no membership for qliksenserepository and therefore it might lack on the proper rights.

- Marcus

Partner
Partner

Re: Error Msg from PostgreSQL

The Sense Repository service is a PostgreSQL database.
Its program files are found under Qlik/Sense/Repository/

Sense does not use usergroup membership for rights.
Sense services use certificates for verification of internal communication.
The database service though is a pure PostgreSQL database thus it uses PostgreSQL user accounts.

wayneantinore-a
Contributor

Re: Error Msg from PostgreSQL

Hi Christoph, did you get a solution to this? I noticed this as well when reviewing my Qlik Sense Servers.

Thanks,
Wayne