Sample Header Ad - 728x90

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