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
atcharacter 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"
duringinlining
> 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@aklaver.com