Skip to main content
2 of 2
tags, format, minor edtis
Erwin Brandstetter
  • 182.1k
  • 28
  • 457
  • 620

Error during pg_restore: text search dictionary "unaccent" does not exist

I'm trying to move data between servers. I recreated the whole database structure, checked that same users exist and the unaccent extension that we use is enabled for all schemas of the target database.

When I try to run:

pg_restore -h %server_host% -a -c --disable-triggers -d %db_name% -U %user_name% 2014-12-09.custom

I get the following error:

pg_restore: [archiver (db)] COPY failed for table "contracts":
ERROR:  text search dictionary "unaccent" does not exist

What am I missing here?