Re: database replication

On Tue, 10 Sep 2002, lego lego wrote:

Hello,

> i want to ask if someone have experiance with data
> replication for postgres. I know there is project
> called postgres-r going on but it's still
> unfinnished. But I need much simplier system more
> mysql like. Having one server for insert that
> are propagated to other servers used just for
> selects.

There are some attempts at replication. One is rserv, which is included
in contrib/. It's not very well documented, but it gets the job done if
you look at it very hard. If you want better support or more perfomance,
you can ask the guys at www.pgsql.com, as they sell a commercial
version.

There are others, but this one should be enough.

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
Si no sabes adonde vas, es muy probable que acabes en otra parte.