On 01/15/13 13:14, Amitabh Kant wrote: > 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 >
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
signature.asc
Description: OpenPGP digital signature
