Sowjanya, You put the ddl into the sql file to run via slonik execute script and the changes are made by slony on the origin and all subscribed nodes.
You shouldn't be doing any ddl on replicated tables outside of slonik. Glyn --- On Mon, 10/5/10, sowjanya v <[email protected]> wrote: From: sowjanya v <[email protected]> Subject: [Slony1-general] Need Urgent Help To: [email protected] Date: Monday, 10 May, 2010, 6:29 Hi, I have two databases db1 and db2. db2 is replica of db1. Now i have added a column in a table in db1. Since schema changes do not propogate by itself to db2, need to execute execute script. But the input for that is a sql file with all difference in schema. Hence please let me know how replicate the schema changes. If i do the diff of two schemas, it only shows the lines where the difference is present and not the sql command to be executed on db2 to make it same as db1. Please do reply immediately. -- Sowjanya Wipro Technologies Bangalore -----Inline Attachment Follows----- _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
