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 A13B852820 for ; Mon, 4 Jul 2005 16:37:35 -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 89125-01 for ; Mon, 4 Jul 2005 19:37:26 +0000 (GMT) Received: from mail.libertyrms.com (unknown [207.219.45.62]) by svr1.postgresql.org (Postfix) with ESMTP id 0A79A5288B for ; Mon, 4 Jul 2005 16:37:22 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1DpWku-0003Cy-4f for pgsql-admin@postgresql.org; Mon, 04 Jul 2005 15:37:24 -0400 Message-ID: <42C98FF3.80400@ca.afilias.info> Date: Mon, 04 Jul 2005 15:37:23 -0400 From: Brad Nicholson User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: replication for hot-standby? References: <42c54261$0$22444$8fe63b2a@news.disputo.net> In-Reply-To: <42c54261$0$22444$8fe63b2a@news.disputo.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/20 X-Sequence-Number: 18076 Hannes Dorbath wrote: > I need something that is able to replicate schema changes as well, so > Slony seems out of the game :/ > > pg_cluster? > mammoth postgresql? > db_mirror? > > What to use for a hot-standby box? > > Thanks in advance > Slony handles schema changes: http://gborg.postgresql.org/project/slony1/genpage.php?slonik_commands#stmt_ddl_script -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.