Alex Haugg a écrit :
> hi,
> 
> i have a tiny problem,
> 
> i need a db dump command without slony configurations (without:
> slony_cluster, slony functions and without slony trigger).
> 
> thanks for your answer,
> 
> alexander haugg

Hi,

It's not a problem, indeed :-)

You may copy the whole master database to a new temporary database (pg_dump).
Then, you issue the SQL command "select _REPLICATION.uninstallnode();" on the
temp database.
Finally you can drop the slony schema on the temp database : "drop schema
_REPLICATION cascade;"

You can then dump the temporary database. It should be free of all slony stuff.

Be aware that you have to dump the master database to create the temporary one,
otherwise you won't get the whole schema of your database (you may lack some
triggers, for instance).

Regards,
-- 
Stéphane SCHILDKNECHT
Président de PostgreSQLFr
Tél. 09 53 69 97 12
http://www.postgresqlfr.org