From owner-freebsd-questions@FreeBSD.ORG Tue Jan 15 12:14:52 2013 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id 7583E1C4 for ; Tue, 15 Jan 2013 12:14:52 +0000 (UTC) (envelope-from amitabhkant@gmail.com) Received: from mail-pb0-f41.google.com (mail-pb0-f41.google.com [209.85.160.41]) by mx1.freebsd.org (Postfix) with ESMTP id 41160228 for ; Tue, 15 Jan 2013 12:14:51 +0000 (UTC) Received: by mail-pb0-f41.google.com with SMTP id xa7so9308pbc.14 for ; Tue, 15 Jan 2013 04:14:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=dCeZjfrY2VNbsHBW4Pf6FmwMEBkXxOUs87QlMpQrXp8=; b=uSMLOo1cx8N1IRn3PU6D+UqBVlQ617HNwiLfsMXPoEGj8sX/OrLX9U2Sa2fzBuo7fN o0oqaVJLlOGMQhnweOI8mpmz+RetMOdIfMn6zk3smSgKZI/qaQNEr6MhV3+t2FZfH8Vp w+0vK+IwD6hX73TIF9u6gO6qYdhF2DB5LRH9XZ+xEHV22sPuxH/GC6CPx2QciR9Jp/0j rRHSWzslvms3HK3G1xtccuFqJK6zgbqNaOiHGjAdli8sf1hDJSYq6ko3wQZHCVn/1LbC AVVkTWCdB5AZN87k0FUvwEgkzWROgxIMYpQhlCKUSSOmLt4U1vc0OP/oPNJhXTlPvYsx aGYw== Received: by 10.66.90.1 with SMTP id bs1mr241246251pab.19.1358252091703; Tue, 15 Jan 2013 04:14:51 -0800 (PST) MIME-Version: 1.0 Received: by 10.68.125.162 with HTTP; Tue, 15 Jan 2013 04:14:31 -0800 (PST) In-Reply-To: <50F53548.9010004@zedat.fu-berlin.de> References: <50F53548.9010004@zedat.fu-berlin.de> From: Amitabh Kant Date: Tue, 15 Jan 2013 17:44:31 +0530 Message-ID: Subject: Re: databases/postgresql: simple mirroring of a database or a whole server To: "O. Hartmann" Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.14 Cc: "freebsd-questions@freebsd.org" 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: Tue, 15 Jan 2013 12:14:52 -0000 On Tue, Jan 15, 2013 at 4:24 PM, O. Hartmann wrote: > Hello list. > > First, please set me CC, i do not subscribe this list. > > I'd like to ask for a mirroring solution of an important databse on my > installations across at least three boxes. The setup is as follows. > > Operating system is FreeBSD 10.0/amd and 9.1-STABLE/amd64. A top of the > OS there is on all machines in question port > databases/postgresql92-server|client running. > > I have a database that needs to be synchronized/mirrored. A data > consistency in a narrow timeframe isn't necessary. The database in > question is a very important literature reference db which is maintained > via a web interface and this is done mostly from a private box at home, > which changes the local database set. This database is also used at the > lab. Usually, I have to dump the db, send it via ssh/scp over the net to > the target machine and restore it - and this at least three times. Since > network connectivity isn't available for some technical reasons when I > maintain the local db at home, this task is a pain, if I forget to > dump/restore the database. The task maintaining the databases like that > isn't appreciable. > > So, I looked out for a mirroring solution. I came across SLONY I/II, but > I feel not very comfortable with the complicated setup. Although having > had a howto, it dind't work properly. So I'm looking for something more > simple. > > The data consistency within short timeframes isn't so important, so a > mission critical mirroring isn't necessary. But I would be feel better > having something more "automatic" that is synchronizing more than two or > three machines automatically when network connectivity is available. > > Is there a solution - easy task - to handle such a scenario? > > Thanks in advance, > Oliver > > Since you are using postgresql 9.2, why don't you use the inbuilt replication that comes with it. You might be interested in this page http://www.postgresql.org/docs/9.2/static/high-availability.html . In case you face any difficulties, u can always head over to pgsql mailing list. (pgsql-general@postgresql.org) Amitabh