Re: postgresql and replication

Look at User Mode Linux:

http://user-mode-linux.sourceforge.net/

It'll let you run multiple linux instances on the same box.

On Wed, 27 Aug 2003, Thierry Missimilly wrote:

> 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@postgresql.org)
>