Re: No enough privileges for autovacuum worker

On 3/23/21 9:45 AM, Андрей Сычёв wrote:
> I do not know who is running dict.trigrams_vector.
> 
> There is no explicit call for this function.
> 
> It is used implicitly in the index definition for the table fpbackup.fp_vpn_data_2021w12:
> 
> CREATE INDEX fp_vpn_data_2021w12_trigrams_vector_idx ON fpbackup.fp_vpn_data_2021w12 USING gin
(dict.trigrams_vector((fp_host)::text));

Aah, I missed that.

> 
> As  I know there is no explicit call for dict.trigrams_vector by me or
> anyone else.

The error is happening when the auto analyze opens the index on the 
table, though I will have to admit that I don't know why?

What happens if you do a manual ANALYZE on the table?

> 
>  From the database  logs  I cannot figure out what user is responsible for
> calling  this  function  as user field in the log in ordinary situation should be, for example, [user@dbname],
> not [(at)]
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com