greg1457 <greg1457@xxxxxxxxxxxxxx> writes: > I migrated an postgresql instance from 9.5.4 to 9.5.21. > Unaccent extension is installed in the database, in "application" schema. > Since this migration, when i do a vaccumdb, i obtain an error : > vacuumdb: vacuuming of database "application" failed: ERROR: function unaccent(text) does not exist > LINE 2: SELECT lower(unaccent($1)); This is probably a search_path problem. You've got an index expression somewhere with a SQL function that is not being careful about which schema(s) to look for "unaccent()" in. There were security fixes to restrict the search path that VACUUM/ANALYZE runs with, which breaks functions that aren't careful about that. regards, tom lane
