From owner-freebsd-ports@FreeBSD.ORG Sat Feb 16 13:55:33 2013 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id B059270 for ; Sat, 16 Feb 2013 13:55:33 +0000 (UTC) (envelope-from cmt@burggraben.net) Received: from smtp.burggraben.net (base.exwg.net [IPv6:2a01:4f8:140:50a2::2]) by mx1.freebsd.org (Postfix) with ESMTP id 4AFFAB20 for ; Sat, 16 Feb 2013 13:55:33 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by smtp.burggraben.net (Postfix) with ESMTP id 056826003CD for ; Sat, 16 Feb 2013 14:55:32 +0100 (CET) X-Spam-Scanned: by amavisd-new at exwg.net Received: from smtp.burggraben.net ([127.0.0.1]) by localhost (ns.burggraben.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id InsNja8Q7-aC for ; Sat, 16 Feb 2013 14:55:31 +0100 (CET) Received: from elch.exwg.net (dslb-088-066-015-247.pools.arcor-ip.net [88.66.15.247]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "elch.exwg.net", Issuer "Christoph Moench-Tegeder" (verified OK)) by smtp.burggraben.net (Postfix) with ESMTPS for ; Sat, 16 Feb 2013 14:55:31 +0100 (CET) Received: by elch.exwg.net (Postfix, from userid 1000) id 8E7013083B; Sat, 16 Feb 2013 14:55:30 +0100 (CET) Date: Sat, 16 Feb 2013 14:55:30 +0100 From: Christoph Moench-Tegeder To: freebsd-ports@freebsd.org Subject: Re: PostgreSQL 9.2: database replication on demand - easy way (Bucardo in ports not available) Message-ID: <20130216135529.GA2072@elch.exwg.net> References: <511F7AED.6070106@zedat.fu-berlin.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <511F7AED.6070106@zedat.fu-berlin.de> User-Agent: Mutt/1.5.21 (2010-09-15) X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 16 Feb 2013 13:55:33 -0000 ## O. Hartmann (ohartman@zedat.fu-berlin.de): > I feel realy uncomfortable with the built-in streaming replication of > PostgreSQL 9.2 since I never managed it to make a successful > replication. As far as I understand, the streaming mechanism of > PostgreSQL 9.X expects the "slaves" to be always online, to which the > replication. The streaming replication is able to recover after "some" connectivity loss, provided you still have enough transaction log (WAL) available on the master. See configuration parameter "wal_keep_segments" and it's description. Have you looked at databases/postgresql-repmgr? Otherwise, I'm not that much of help with this, as the postgresql clustering I'm doing at work runs under linux and is rather proprietary (the underlying cluster technology has been developed by us). OTOH, aside from the integration with our cluster, everything I did to get the replication running should be very portable. Regards, Christoph -- Spare Space