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 158D452802 for ; Sat, 2 Jul 2005 08:29:11 -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 85040-04 for ; Sat, 2 Jul 2005 11:29:07 +0000 (GMT) Received: from titan.ecommit.de (titan.ecommit.de [195.145.58.245]) by svr1.postgresql.org (Postfix) with ESMTP id BDA405297D for ; Sat, 2 Jul 2005 08:29:05 -0300 (ADT) Received: from titan.ecommit.de (localhost [127.0.0.1]) by titan.ecommit.de (8.12.6/8.12.6/SuSE Linux 0.6) with ESMTP id j62BSx0F025622; Sat, 2 Jul 2005 13:29:08 +0200 Received: from titan.ecommit.de (root@localhost) by titan.ecommit.de (8.12.6/8.12.6/Submit) with ESMTP id j62BSxOT025621; Sat, 2 Jul 2005 13:28:59 +0200 Received: from [192.168.0.12] (p54A6385C.dip.t-dialin.net 84.166.56.92) by titan.ecommit.de (Scalix SMTP Relay 9.0.0.26) via ESMTP; Sat, 02 Jul 2005 13:28:58 +0200 (CEST) Date: Sat, 2 Jul 2005 13:28:51 +0200 From: "Martin Fandel" To: Hannes Dorbath Cc: pgsql-admin@postgresql.org Message-ID: <1120303732.24725.5.camel@localhost.localdomain> In-Reply-To: <42c54261$0$22444$8fe63b2a@news.disputo.net> References: <42c54261$0$22444$8fe63b2a@news.disputo.net> Subject: Re: replication for hot-standby? x-scalix-Hops: 1 X-Mailer: Evolution 2.0.4 (2.0.4-4) Mime-Version: 1.0 Content-Type: text/plain Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.033 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/7 X-Sequence-Number: 18063 Hi, maybe filesystem-snapshots with wal's are your solution. There is a block-device replication-tool too. It's called drbd (http://www.drbd.org). I never tested/used it, but i heard it should be fine. I'm using rsync/xfs_freeze to make incremental filesystem-snapshots (incremental by hardlinks). This works fine/reliable for me :). best regards, Martin Am Freitag, den 01.07.2005, 15:51 +0200 schrieb Hannes Dorbath: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster