Yes, it does in /some way/, but it's quite hackish and error prone.. :/

If there is anything broken about the script, or about how it executes on a 
particular node, this will cause the slon daemon for that node to panic and 
crash. If you restart the node, it will, more likely than not, try to repeat 
the DDL script, which will, almost certainly, fail the second time just as it 
did the first time.

Unfortunately, this nonetheless implies that the use of the DDL facility is 
somewhat fragile and fairly dangerous.

If your applications do not have fairly stable SQL schemas, then using Slony-I 
for replication is likely to be fraught with trouble and frustration.

Sorry, this really doesn't sound like something I'd like to use in a production environment..


On 04.07.2005 21:37, Brad Nicholson wrote:
Slony handles schema changes:
http://gborg.postgresql.org/project/slony1/genpage.php?slonik_commands#stmt_ddl_script

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to