Tue Jan 4 00:31:38 PST 2011
- Next message: [Slony1-general] How do we change IP of origin?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hey, Recently, unknowingly, we dropped a table on the master db which was a part of Slony replication without it going through the Slony script. This table is however present on the mirror/replicated db. I read somewhere, and want to confirm if the following hack will work. Dropped table name : foo tab_id in sl_table : 20 * Create a new table named "foo" with the same schema as the original dropped table * Add trigger on the master table with name "_mirror_logtrigger_20"(as created on other replicated tables) * Update sl_table with the new oid. * All done, now drop the table via the slop drop script? Thanks for help in advance -- Anooj Narvekar
- Next message: [Slony1-general] How do we change IP of origin?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list