From: | Андрей Сычёв <andrey(dot)sychev(at)cifrasoft(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: No enough privileges for autovacuum worker |
Date: | 2021-03-24 08:16:38 |
Message-ID: | 3510602133.20210324121638@cifrasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I finally figured out how to tackle the problem:
1. When I manually execute ANALYZE on the table the error remains:
[34938]-[192.168.67.81]-[DBeaver 7.3.2 - SQLEditor <Script-2.sql>]-[client backend]-[42501]-[postgres(at)fpdb] CONTEXT: SQL function "trigrams_vector" during inlining
[34938]-[192.168.67.81]-[DBeaver 7.3.2 - SQLEditor <Script-2.sql>]-[client backend]-[42501]-[postgres(at)fpdb] STATEMENT: ANALYZE fpbackup.fp_vpn_data_2021w12
[31203]-[]-[]-[autovacuum worker]-[42501]-[(at)] ERROR: permission denied for schema dict at character 34
[31203]-[]-[]-[autovacuum worker]-[42501]-[(at)] QUERY:
_to_string(dict.trigrams_array($1), ' ')::tsvector;
This happens despite I run this query as superuser. But the hint from you
allows me to manually reproduce error.
2. As I wrote before the owner of the table
fpbackup.fp_vpn_data_2021w12 is "fpbkwriter"
so I run the following query:
GRANT USAGE
ON SCHEMA
dict
TO fpbkwriter;
and after that the problem has been solved.
3. The following queries do not affect the problem:
GRANT EXECUTE
ON ALL FUNCTIONS IN SCHEMA
dict
TO fpbkwriter;
REVOKE EXECUTE
ON ALL FUNCTIONS IN SCHEMA
dict
FROM fpbkwriter;
--
Adrian, thank you very much for support.
Your hints were very useful.
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Millas | 2021-03-24 14:41:45 | Re: need clarification on CTE/join |
Previous Message | Albrecht Dreß | 2021-03-24 08:01:03 | ERROR: could not attach to dynamic shared area |