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
[-- Attachment #1 --] 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: > >> 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 > 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 [-- Attachment #2 --] -----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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?50F54F7E.4020402>