On Fri, 5 Aug 2005, Marco Rademeyer wrote:
Can PostgreSQL do replication ?
Marco,
This would probably be a good one to search for in the archives before asking,
but Slony http://slony.info/ is probably the most popular replication engine
for postgresql and command prompt has Mammoth Replicator which I have also
heard good things about: http://commandprompt.com/products/mammothreplicator/
In addition, you could probably set up a PITR based replication solution like
the one I set up for one of my clients. The general gist of the solution is
doing a base backup on a regular basis to the secondary server and archiving
the WAL files to a shared storage medium for replay.
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
