Thu May 18 08:36:21 PDT 2006
- Previous message: [Slony1-general] Replicating existing data after slony installation
- Next message: [Slony1-general] Can't remove dropped table from slony set--
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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. ######################################################################
- Previous message: [Slony1-general] Replicating existing data after slony installation
- Next message: [Slony1-general] Can't remove dropped table from slony set--
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list