On 9/16/2008 2:25 PM, Glyn Astill wrote:
> Hi Chaps,
> 
> I've got a test setup with slony replicating two databases on the same postgres instance, e.g. I've a table "price" in database SEE and SEE_REP on the same host and I'm replicating it with slony from SEE to SEE_REP.
> 
> What I've tried to do is pg_dumpall then re-initdb the server, reload the dump back in and then run REPAIR CONFIG.

It is well documented that you cannot use pg_dump to retrieve the schema 
of a subscriber. pg_dumpall uses pg_dump underneath to create combined 
schema+data dumps of all databases. This only works with Slony 2.0.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin