Tue Jul 8 06:46:43 PDT 2008
- Previous message: [Slony1-general] Drop Table
- Next message: [Slony1-general] Drop Table
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Drop Table
- Next message: [Slony1-general] Drop Table
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list