On Thu, Apr 08, 2004 at 11:48:19AM +1000, Jamie Wilkinson wrote: > This one time, at band camp, Howard Lowndes wrote: > >Is anyone doing database replication from Postgresql? > > There is a bit of software called Mammoth which I believe has been > donated to the postgresql project, but that's all I know about it.
Almost. Mammoth is a commercial release of postgresql, and they have a replicator option, which looks quite nice, but is non-free (although source available): http://www.commandprompt.com/entry.lxp?lxpe=304 We spent some time looking at postgresql replication again recently, and it depends a lot on what you're wanting it for - there's at least this many kinds of driver: * HA/Failover (roll over to replica, usually LAN-based) (Master/slave, sync or async) * Load balancing (use a number of smaller boxen) (Multi-master, sync or async + conflict resolution) * Data warehousing (read replicas for insane read queries) (Async master/slave) * Disaster recovery (replication to remote WAN-based servers) (Async master/slave or multi-master) * Mobile servers (laptops!) (Async multi-master + conflict resolution) Most of the current postgresql replication options (including the commandprompt one) seem to handle async master-slave stuff reasonably well, but multi-master and/or synchronous versions are non-existent or experimental. If that's what you need, then you probably want to go the shared storage route instead of the application-level replication route, whether hardware or software based. Cheers, Gavin -- Open Fusion P/L - Open Source Business Solutions [ Linux - Perl - Apache ] ph: 02 9875 5032 fax: 02 9875 4317 web: http://www.openfusion.com.au mob: 0403 171712 - Fashion is a variable, but style is a constant - Programming Perl -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
