From owner-freebsd-questions@FreeBSD.ORG Tue Jan 15 12:46:00 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 1CCAFCDD for ; Tue, 15 Jan 2013 12:46:00 +0000 (UTC) (envelope-from ohartman@zedat.fu-berlin.de) Received: from outpost1.zedat.fu-berlin.de (outpost1.zedat.fu-berlin.de [130.133.4.66]) by mx1.freebsd.org (Postfix) with ESMTP id BA1AF3CC for ; Tue, 15 Jan 2013 12:45:59 +0000 (UTC) Received: from inpost2.zedat.fu-berlin.de ([130.133.4.69]) by outpost1.zedat.fu-berlin.de (Exim 4.69) with esmtp (envelope-from ) id <1Tv5tu-003RU7-Iz>; Tue, 15 Jan 2013 13:45:58 +0100 Received: from telesto.geoinf.fu-berlin.de ([130.133.86.198]) by inpost2.zedat.fu-berlin.de (Exim 4.69) with esmtpsa (envelope-from ) id <1Tv5tu-001vDY-Gd>; Tue, 15 Jan 2013 13:45:58 +0100 Message-ID: <50F54F7E.4020402@zedat.fu-berlin.de> Date: Tue, 15 Jan 2013 13:45:50 +0100 From: "O. Hartmann" User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:17.0) Gecko/20130110 Thunderbird/17.0.2 MIME-Version: 1.0 To: Amitabh Kant Subject: Re: databases/postgresql: simple mirroring of a database or a whole server References: <50F53548.9010004@zedat.fu-berlin.de> In-Reply-To: X-Enigmail-Version: 1.4.6 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig426962BBBE83D412DB08A19B" X-Originating-IP: 130.133.86.198 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:46:00 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig426962BBBE83D412DB08A19B Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 01/15/13 13:14, Amitabh Kant wrote: > On Tue, Jan 15, 2013 at 4:24 PM, O. Hartmann wrote: >=20 >> 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 th= e >> 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 maintain= ed >> 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 th= e >> 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. Sin= ce >> 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 tha= t >> isn't appreciable. >> >> So, I looked out for a mirroring solution. I came across SLONY I/II, b= ut >> I feel not very comfortable with the complicated setup. Although havin= g >> had a howto, it dind't work properly. So I'm looking for something mor= e >> 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 . >=20 > In case you face any difficulties, u can always head over to pgsql mail= ing > list. (pgsql-general@postgresql.org) >=20 > Amitabh >=20 Thank you very much for this hint! I'm new to the 9.X series, so I didn't realize that there is something new built-in. Valuable hint. Regards, Oliver --------------enig426962BBBE83D412DB08A19B Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) iQEcBAEBAgAGBQJQ9U+GAAoJEOgBcD7A/5N8VnkH/R5fRscnQQk4i7ThA7jAk40+ vA+d4iqxg8pSaPykjSVcGQgiMflN3y2DgOUw1e4yJCunK+dcO//g8YW6Q0kNXm7F 4XymZd633MABeVNKiWF5CIsyFPGU57yjVMgZ0pS8fybhexk+yLD/5jqHldY9jjNl EbNBQW3qvfyuAnqbsHt2AxRb2/QGvhndtBpMJRkEMnGSIROcIIpu7Sq89CKFZnBM IbQ5nb1vn4exJ97yPWHBHdRcoVrJzON/ytFnGE3u2G9TYCaiHUSdVNDdfvK/5faZ 9F+NAj3pt9d69jGKZ1YGANbyxYVfV72OpbzLwlAX53KRfQIIvAUo5ygIGJbz7kE= =5hsd -----END PGP SIGNATURE----- --------------enig426962BBBE83D412DB08A19B--