Date: Tue, 15 Jan 2013 13:45:50 +0100 From: "O. Hartmann" <ohartman@zedat.fu-berlin.de> To: Amitabh Kant <amitabhkant@gmail.com> Cc: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org> Subject: Re: databases/postgresql: simple mirroring of a database or a whole server Message-ID: <50F54F7E.4020402@zedat.fu-berlin.de> In-Reply-To: <CAPTAQBL_oDALAkdSeGywfkbjZ2t3Xb5mEcXVXkVctjwUuatBmQ@mail.gmail.com> References: <50F53548.9010004@zedat.fu-berlin.de> <CAPTAQBL_oDALAkdSeGywfkbjZ2t3Xb5mEcXVXkVctjwUuatBmQ@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <ohartman@zedat.fu-berlin.= de>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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?50F54F7E.4020402>