X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B7AD852822 for ; Tue, 5 Jul 2005 05:22:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35204-04 for ; Tue, 5 Jul 2005 08:22:46 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 206EA5281E for ; Tue, 5 Jul 2005 05:22:46 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j658MjJd035534 for ; Tue, 5 Jul 2005 08:22:45 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j657sQSa030847 for pgsql-admin@postgresql.org; Tue, 5 Jul 2005 07:54:26 GMT (envelope-from news) Date: Tue, 05 Jul 2005 10:00:06 +0200 From: Hannes Dorbath User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 X-Newsgroups: pgsql.admin Subject: Re: replication for hot-standby? References: <42c54261$0$22444$8fe63b2a@news.disputo.net> <42C98FF3.80400@ca.afilias.info> In-Reply-To: <42C98FF3.80400@ca.afilias.info> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 16 Message-ID: <42ca35fb$0$22442$8fe63b2a@news.disputo.net> Organization: FirstUseNet Intermedia GmbH X-Complaints-To: abuse@disputo.de To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200507/22 X-Sequence-Number: 18078 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 >