[Bucardo-general] debugging KID SQL errors

Greg Sabino Mullane greg at endpoint.com
Tue Sep 28 00:33:31 UTC 2010


> Sep 27 20:20:45 database3 Bucardo[12576]: KID Kid exiting at cleanup_kid. 
> Reason: DBD::Pg::st execute failed: ERROR:  schema "bucardo" does not exist.

Just a random stab, but does validate sync return without an error?

$ bucardo_ctl validate <syncname>

> Reason: DBD::Pg::st execute failed: ERROR:  syntax error at or near ","
...
> For the second one, I'd like to figure out what's going on here, but I'm not 
> sure how to do that.

The best way to do that is to look in the Postgres logs, which should 
show you the exact query that generated the error above.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100927/a78576ea/attachment.bin 


More information about the Bucardo-general mailing list