[Bucardo-general] Bucardo sync not running
Michelle Sullivan
michelle at sorbs.net
Sun Nov 4 00:01:57 UTC 2018
Check the delta table size...
psql -U <a super user> <database>
Db=# SET SCHEMA bucardo;
Db=# SELECT COUNT(1) FROM bucardo.bucardo_<tablename>_delta;
... repeat for all <tablenames> in the sync, see how many changes there are...
If a low number try VACUUM VERBOSE FULL ANALYZE bucardo.bucardo_<tablename>_delta; for each table.
Michelle Sullivan
http://www.mhix.org/
Sent from my iPad
> On 04 Nov 2018, at 05:27, Christophe Pettus <xof at thebuild.com> wrote:
>
>
>
>> On Nov 1, 2018, at 09:35, David Christensen <david at endpoint.com> wrote:
>>
>> So this is the same on source/target? Anything happening in the “bucardo” database?
>
> On the source database, all the Bucardo connections are in place, but idle; same on the bucardo database.
>
>> Is this multi-master or single master?
>
> Single master.
>
> Thanks!
> --
> -- Christophe Pettus
> xof at thebuild.com
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
More information about the Bucardo-general
mailing list