On 8 September 2011 15:02, Steve Singer <[email protected]> wrote: > On 11-09-08 06:42 AM, Glyn Astill wrote: >> Hi Guys, >> >> Since we were on slony 1.2 I've been doing full pg_dumps from our >> servers, and restoring them onto a test setup daily. >> >> Since we've moved to 2.0 I've noticed that those full dumps now cause >> the subscribers to lag. I just wanted to ask - is this expected >> behaviour in 2.0? And is the only real workaround skipping the schema >> during pg_dump? > > Yes this is expected behaviour. The only work around is to skip the > slony schema in pg_dump.
Notably, the --exclude-schema option was added to pg_dump specifically to facilitate Slony users. -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
