[Bucardo-general] bucardo_truncate_trigger error

[Michelle Sullivan]

It would be easier to diagnose if you have screen shots of the install/configure...

Basically though, I’d suspect at a point in the installation/configure you were using a credential that was unable to write/see the bucardo schema... if this is the case you may find the sync won’t actually work even after adding the required table.

Michelle Sullivan
http://www.mhix.org/
Truth is the beginning of the Path.

> On 12 Nov 2021, at 05:50, Victor Nunes <victor at teamnext.com.br> wrote:
> 
> Hey guys ! I'm trying to use bucardo and I'd like to communicate you guys about something.
> 
> After running bucardo install and configure sync, I got the message: "relation bucardo_truncate_trigger does not exists".
> 
> I solved it running the create table command by myself, like that:
> 
> CREATE TABLE bucardo.bucardo_truncate_trigger (
>     tablename   OID         NOT NULL,
>     sname       TEXT        NOT NULL,
>     tname       TEXT        NOT NULL,
>     sync        TEXT        NOT NULL,
>     replicated  TIMESTAMPTZ     NULL,
>     cdate       TIMESTAMPTZ NOT NULL DEFAULT now()
> );
> 
> Apparently works, but I imagine this isn't the right way.
> 
> Can you guys help me with this?
> 
> Hugs,
> 
> Victor Silva,
> Tech Lead at Team Next.
> teamnext.com.br
> +55 (11) 97376-6363
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://bucardo.org/mailman/listinfo/bucardo-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211112/5aa9fc73/attachment.htm>