Re: No enough privileges for autovacuum worker

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]-[(at)] ERROR: permission denied for schema dict at character 34
> 2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[(at)] QUERY:
> SELECT array_to_string(dict.trigrams_array($1), ' ')::tsvector;
>
> 2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[(at)] 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(at)%d] '
>
> PostgreSQL version 13.
>
>
> Any ideas?
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com