On Tue, Jan 15, 2013 at 4:24 PM, O. Hartmann <ohart...@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-gene...@postgresql.org) Amitabh _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
