[Bucardo-general] Sync issues with unaccent function

Fernando Wiek fernandowiek at gmail.com
Thu Feb 22 18:20:29 UTC 2018

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.
  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

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>

More information about the Bucardo-general mailing list