Date: Sat, 16 Feb 2013 14:55:30 +0100 From: Christoph Moench-Tegeder <cmt@burggraben.net> 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> In-Reply-To: <511F7AED.6070106@zedat.fu-berlin.de> References: <511F7AED.6070106@zedat.fu-berlin.de>
next in thread | previous in thread | raw e-mail | index | archive | help
## 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20130216135529.GA2072>