Re: Replication

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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954