Re: postgresql and replication

Hi,

This is a good status.
But i think you have forgotten DBMirror which is in the contrib directory.
I have tried to run it on the same machine but on to 2 differents Postgres
instances. The master on Port 5432 and the Slave on Port 5434. These does
not work as the Perl script in charge of synchronized the Master DB and the
Slave DB, work only on the default port 5432.

I'm waiting for an other machine to create the Slave DB on a different
machine.

Thierry Missimilly

Chris Miles wrote:

> Hi, we really want to get a reliable PostgreSQL replication
> setup going, with a Master Write server and many Slave Read-Only
> servers replicating off the master. This is to allow us to
> scale up our low-write/high-read application over many customers.
>
> We've done some research (ie, web searching) and we are not
> convinced that PostgreSQL replication projects are production
> ready (with one commercial exception). Hopefully we are wrong
> however, as the MySQL built-in replication does seem very mature
> and makes me look across with envy. But considering all the effort
> we've put into our PG installation, we'd rather stick to PG if
> possible.
>
> I will briefly list the PG Replication projects I have come across
> below. I am looking for more experienced people, who have hopefully
> already implemented any of these, or the authors themselves, to
> provide more details and guide us in the right direction as to
> which project is the "best" to go with. I am happy to summarize
> the info we put together for others looking to do the same.
>
> eRServer
> http://www.erserver.com/
> Commercial, looks professional. Not free.
> However, No trial or evaluation ?
>
> PGReplication
> http://gborg.postgresql.org/project/pgreplication/projdisplay.php
> Software is: Postgres-R with Spread. Free.
> Looks to be still very much in development, can only consider beta ?
>
> RServ
> http://gborg.postgresql.org/project/rservimp/projdisplay.php
> Looks far too beta....
> Free
>
> PostgreSQL Replicator
> http://pgreplicator.sourceforge.net/
> “Store and forward” asynchronous data replication.
> Free
> Tested up to PG 7.1
> Peer-to-peer (single master/slave pair) not multi-slave.
>
> Usogres
> http://usogres.good-day.net/
> Very simple and not real-time replication. Free.
> Just duplication and only one master/slave pair.
>
> Regards,
> Chris.
>
> --
> Chris Miles
> http://chrismiles.info/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)