Filip Rembia?kowski a écrit :
> 2007/6/29, Raymond O'Donnell <rod at iol.ie>:
>> On 28/06/2007 23:17, Christopher Browne wrote:
>>
>> > There's a further "wish list" we're looking at, for which it seems
>> > timely to solicit additions:
>>
>> Maybe I'm missing something blindingly obvious (I'm pretty inexperienced
>> with Slony), but would it be possible to produce a tool that allows a
>> dump of a replicated node *without* all the extra stuff Slony adds - the
>> extra schema, triggers, etc. - in other words, output similar to that
>> produced by pg_dump on an unreplicated database?
>
> Good point IMHO; similar need here. I guess many people need this.
>
> To produce a "clean" dump ( that is, without Slony-I schema and
> triggers ) we have to install temporary backup node, wait for it to
> catch up, DROP NODE it , and dump it. Whole process takes almost
> twice longer as plain pg_dump (and is more failure-prone)
>
In order to get the schema, I personnaly use slony1_extract_schema.sh
and slony1_dump.sh to get the data.

Isn't it what you're looking for ?

Regards,

-- 
Stéphane SCHILDKNECHT
Président de PostgreSQLFr
06 13 60 37 44 - 09 53 69 97 12
http://www.PostgreSQLFr.org