Norman Yamada nyamada
Thu May 18 08:36:21 PDT 2006
We're running slony 1.1.5 with postgresql 8.1.3. We have a master  
node replicating to two slave nodes.

We have a table that's part of a slony set that we wanted to drop  
from the database entirely. Due to miscommunication, one of my  
developers dropped the table from the database on the master node  
before we could drop it from the slony set.

Now we're stuck. I can't drop the table from the slony set, because  
it complains that the table doesn't exist on the master node. I've re- 
created the table on the master node to no avail. Worse, while my  
slony set continues to function even without this table, I can't run  
any other DDL scripts on the set -- it complains about the missing  
table.

What can we do? I'm happy to delete entries from the replication  
schema by hand if I have to, but would rather not recreate the set  
from scratch; it would be a royal pain and we'd lose about 12 hours  
of time.

Thanks in advance for any help; and congrats on a great project!

######################################################################
This e-mail is confidential and should not be redistributed or
forwarded by the recipient.  The information contained in this e-mail
message is intended only for the use of the individual or entity named
above.  If the reader of this message is not the intended recipient or
you have received this communication in error, please immediately
notify us by telephone.  Receipt by anyone other than the intended
recipient is not a waiver of any work-product or, if applicable,
attorney-client privilege.

This e-mail does not constitute an offering of any security.  Such an
offering may only be made by means of a private placement memorandum
or other disclosure document.  Nothing in this e-mail constitutes
investment advice.  Past performance is not indicative of future
results.  All e-mail to and from Millburn Ridgefield Corporation and
its affiliates is monitored, stored and made available to regulators
if requested.
######################################################################



More information about the Slony1-general mailing list