[Bucardo-general] Bucardo sync not running
David Christensen
david at endpoint.com
Sun Nov 4 15:29:01 UTC 2018
Right; needs to be able to complete quickly, as VACUUM FULL will block writes, and hence transactions blocked by the trigger inserts.
> On Nov 3, 2018, at 7:01 PM, Michelle Sullivan <michelle at sorbs.net> wrote:
>
> 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
--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171
More information about the Bucardo-general
mailing list