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 <da...@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@lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
