Replicating PostgreSQL – the easy way – with rubyrep
by Richard Martin on Aug.01, 2009, under Linux admin, PostgreSQL
I’m a great fan of Bucardo for PostgreSQL replication…. it’s stable but quite hard to use…. if you want fire and (not) forget replication try RubyRep…. awesome. The documentation is perfect but to make it even easier, if you are testing and messing around… uninstall, then re-scan, then replicate otherwise you might get some bizarre replication errors, or foreign key contraint issues etc… anything odd, just un-install, then re-scan and replicate. It really is full proof… well it worked for me!
For the cut & paste brigade: (RTFM)
rubyrep generate myrubyrep.conf
rubyrep scan -c myrubyrep.conf
nohup rubyrep replicate -c myrubyrep.conf &
Remember the nohup and the &, to background it, unless you’re actually at the console of the production server – which you probably aren’t…. In fact stick the nohup and & on the scan command too as that could take a few hours on a big DB…
Then tail -f nohup.out to watch the (lack) of output, output is normally bad – loss of connection:
2009-07-31T22:22:13+01:00 Exception caught: no connection to ‘right’ database
and what not… but rubyrep will just keep going once the connection comes back up. Perfect!
