On 8 September 2011 15:02, Steve Singer <ssinger at ca.afilias.info> 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