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.kla...@aklaver.com
