Bill Moran wmoran at collaborativefusion.com
Tue Jul 8 06:46:43 PDT 2008
In response to "Rafael Domiciano" <rafael.domiciano at gmail.com>:

> Hi guys,
> 
> I need to drop a table that is replicated. This table there is no data, and
> it's begin dropped because there is no more use.
> I would like to know how can I drop the table? If a only drop the table in
> the master, will Slony break into error?

Yes, it will.

> Or I need to stop Slony, drop the set correspondent, drop the table, create
> the set and then start the Slony?

You can drop the table from replication first, which is a single Slony
action:
http://slony.info/documentation/stmtsetdroptable.html


Once it's no longer replicated, you can go in to each replica and
issue an SQL DROP TABLE to remove it.  There's no need to stop Slony
or reconfigure replication.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran at collaborativefusion.com
Phone: 412-422-3463x4023


More information about the Slony1-general mailing list