[Bucardo-general] Sync issues with unaccent function

[Fernando Wiek]

Hello,
I configured an RDS Postgres as source and EC2 Postgres as target on
Bucardo 5.5.0. Everything is ok until I tried to create a sync. When I do
this, I get this error:

"WARNING:  Issuing rollback() due to DESTROY without explicit disconnect()
of DBD::Pg::db handle dbname=XXXX;host=XXXXX;port=5432 at -e line 56.
Failed to add sync: DBD::Pg::st execute failed: ERROR:  DBD::Pg::db do
failed: ERROR:  function unaccent(unknown, text) does not exist
LINE 2:   SELECT lower(unaccent('public.unaccent', $1))
                       ^
HINT:  No function matches the given name and argument types. You might
need to add explicit type casts.
QUERY:
  SELECT lower(unaccent('public.unaccent', $1))

CONTEXT:  SQL function "asciify" during inlining at line 128. at line 30.
CONTEXT:  PL/Perl function "validate_sync" at /usr/local/bin/bucardo line
4662."

The extension unncent is working fine on both sides. Anyone could help me
to find the issue?
Best regards.

-- 
Fernando Wiek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180222/775bb492/attachment.html>