Error during pg_restore: text search dictionary "unaccent" does not exist
3
votes
1
answer
2154
views
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?
Asked by jezzarax
(181 rep)
Dec 9, 2014, 08:56 AM
Last activity: Dec 29, 2015, 02:47 PM
Last activity: Dec 29, 2015, 02:47 PM