From owner-freebsd-questions@FreeBSD.ORG Sun Feb 17 22:57:09 2013 Return-Path: Delivered-To: freebsd-questions@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 66B17BE2 for ; Sun, 17 Feb 2013 22:57:09 +0000 (UTC) (envelope-from jcigar@ulb.ac.be) Received: from relaygateway01.edpnet.net (relaygateway01.edpnet.net [212.71.1.210]) by mx1.freebsd.org (Postfix) with ESMTP id EAE81D3F for ; Sun, 17 Feb 2013 22:57:08 +0000 (UTC) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApMBADVfIVHV25ey/2dsb2JhbAANN8AdgReDEgEBAQQ4QBELGAkWDwkDAgECAUUTCAEBF7NriSOJDo1dgWEWgyoDl0mRDYE2 X-IronPort-AV: E=Sophos;i="4.84,683,1355094000"; d="scan'208";a="145827296" Received: from 213.219.151.178.adsl.dyn.edpnet.net (HELO [192.168.0.10]) ([213.219.151.178]) by relaygateway01.edpnet.net with ESMTP; 17 Feb 2013 23:55:56 +0100 Message-ID: <51215FFD.4060200@ulb.ac.be> Date: Sun, 17 Feb 2013 23:55:57 +0100 From: Julien Cigar User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:17.0) Gecko/20130209 Thunderbird/17.0.2 MIME-Version: 1.0 To: freebsd-questions@freebsd.org Subject: Re: PostgreSQL 9.2: database replication on demand - easy way (Bucardo in ports not available) References: <511F7AED.6070106@zedat.fu-berlin.de> In-Reply-To: <511F7AED.6070106@zedat.fu-berlin.de> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 17 Feb 2013 22:57:09 -0000 On 02/16/2013 13:26, O. Hartmann wrote: > Dear Sirs. > > I send my question to this list in the hope someone has the same > problems and already found a solution. I will start explaining the > background and my difficulties with recent solutions. > > We/I have a FreeBSD 10 box running a PostgreSQL 9.2 server containing > literature references via RefDB, some sort of bugtracking via Bugzilla, > several astronomical databases of the IAU (minor planet objects) and > others. Those databases are kept and maintained on one single box at the > department. > > Since a lot of the data is needed in my home office or at a lab with > non-permanent internet connection, I desperately need to synchronize the > databases kept on the "master" with some backup database systems acting > as "master/slave" when they are online. The latter definition is fuzzy, > since what I need is an automated synchronization of the "real" master > with a sporadically upcoming "slave" at home or at field sites for my > science where, as said, the internet connectivity isn't provided 24/7. > > 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. > > I was said that Bucardo (http://bucardo.org/) would be the tool of > choice, but FreeBSD ports seem not not have this tool. SLONY also is a > way to complicated for my for just this task - or I'm to dumb to perform > a solution that fits easily. > > Is someone out here who might have the same problems and already figured > out how to solve this? I do not want to go into this crap "pg_dump", > since I tried this many times and it failed due to some issues I never > figured out why in PostgreSQL 9.2. Sorry being unspecific here, it is a > long time since I tried this frustrating task and it boiled always down > to some confusing "postgres/template1" issues when dumping the master > and trying to update the "slave". Even following the textbook's > suggestions ended up in a mess. > > Well, I appreaciate some hints and concepts (working, not hypothetical > "could be's", those are floating enough around the FreeBSD related net). > > Thanks in advance and thanks for the patience, > > Oliver > perhaps you could do WAL shipping .. ?