On 3/23/21 3:20 AM, Андрей Сычёв wrote:
Hi everyone,
Every minute, I see the following error message in my server logs:
2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[@] ERROR: permission denied for schema dict at character 34
2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[@] QUERY:
SELECT array_to_string(dict.trigrams_array($1), ' ')::tsvector;
2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[@] CONTEXT: SQL function "trigrams_vector" during inlining
automatic analyze of table "fpdb.fpbackup.fp_vpn_data_2021w12"
What is trigrams_vector() doing and does it involve table
fpdb.fpbackup.fp_vpn_data_2021w12?
Also what user is the function running as and does that user have
permissions to schema dict?
It seems that something related to autovacuum does not have enough
privileges to do some particular work, but I have no idea to what
and/or to whom I should grant privileges to fix this problem.
log setting from postgresql.conf:
log_line_prefix = '%m [%p]-[%h]-[%a]-[%b]-[%e]-[%u@%d] '
PostgreSQL version 13.
Any ideas?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
