topic Re: Error Msg from PostgreSQL in Management & Governance

Error Msg from PostgreSQL

chrisg — Wed, 19 Sep 2018 09:38:09 GMT

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

Re: Error Msg from PostgreSQL

marcus_sommer — Wed, 19 Sep 2018 11:06:21 GMT

Maybe: permissions - How do I grant PostgreSQL superuser access to vacuum tables? - Database Administrators Stack Exchange.

- Marcus

Re: Error Msg from PostgreSQL

chrisg — Wed, 19 Sep 2018 13:19:06 GMT

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

Re: Error Msg from PostgreSQL

marcus_sommer — Wed, 19 Sep 2018 14:15:22 GMT

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

Re: Error Msg from PostgreSQL

chrisg — Wed, 19 Sep 2018 14:47:31 GMT

Hi Markus,

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

Re: Error Msg from PostgreSQL

marcus_sommer — Wed, 19 Sep 2018 15:13:04 GMT

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

Re: Error Msg from PostgreSQL

Anders_Eriksson — Thu, 20 Sep 2018 09:41:44 GMT

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.

Re: Error Msg from PostgreSQL

wayne-a — Fri, 16 Nov 2018 13:24:14 GMT

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

Thanks,
Wayne