On 08/24/2015 04:58 PM, Dave Cramer wrote:
>
> On 24 August 2015 at 16:57, Steve Singer <ssinger at ca.afilias.info
> <mailto:ssinger at ca.afilias.info>> wrote:
>
>     On 08/24/2015 04:12 PM, Dave Cramer wrote:
>
>         I am currently waiting on a resubscribe event. How does slony
>         get this
>         event through all the backlog events ?
>
>
>     Usually pretty quickly.
>     Slonik waits for the provider to be caught up before submitting the
>     event.
>
>     The question is, why is your provider behind? Is it getting caught up?
>
>
> I presumed it was behind because one node was missing and this was
> blocking replication.
>
> Note the nodes are chained 1->2, 2->3, 3-4. 3 is the one that failed
>


and a slonik script like
---------------
cluster name=mycluster;
node 1 admin conninfo='...'
node 4 admin conninfo='...'

resubscribe node(origin=1,provider=1,receiver=4);
----------

is waiting?

If so it should tell you from which node it is waiting for events from.




>
>
>         Dave Cramer
>
>         On 24 August 2015 at 15:38, Scott Marlowe
>         <scott.marlowe at gmail.com <mailto:scott.marlowe at gmail.com>
>         <mailto:scott.marlowe at gmail.com
>         <mailto:scott.marlowe at gmail.com>>> wrote:
>
>              Note that the node will still show up in sl_nodes and
>         sl_status for a
>              while, until slony does a cleanup event / log switch (can't
>         remember
>              which right now). This is normal. Don't freak out.
>
>
>
>