Mon May 10 00:58:20 PDT 2010
- Previous message: [Slony1-general] Need Urgent Help
- Next message: [Slony1-general] Need Urgent Help
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 <sowjuec at gmail.com> wrote: From: sowjanya v <sowjuec at gmail.com> Subject: [Slony1-general] Need Urgent Help To: slony1-general at lists.slony.info 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 Slony1-general at lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100510/70f5857e/attachment.htm
- Previous message: [Slony1-general] Need Urgent Help
- Next message: [Slony1-general] Need Urgent Help
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list