steve@ssinger.info steve@ssinger.info steve at ssinger.info
Thu Jul 11 10:10:43 PDT 2019
14GB isn't very big.
Any idea what is happening?

Are there any locks on the table (on the origin or replica) that could be preventing this?

What is in the slon log, for the slon for the replica.
Did the COPY start?

Did the replica get some data and then things hung?




> On July 11, 2019 at 12:31 PM David Fetter <david at fetter.org> wrote:
> 
> 
> Hi,
> 
> This is on Slony 2.2.7, PostgreSQL 9.5.  I'm trying to replicate a
> 14GB table which is receiving no writes, but the initial sync goes for
> days without completing.  At first, I thought there might be an issue
> with the write rate, but it's zero.
> 
> Are there any settings I can tweak to make the initial sync work?  I'd
> be willing to patch Slony if that's what's needed.
> 
> Best,
> David.
> -- 
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778
> 
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


More information about the Slony1-general mailing list