Postgres Pro
Downloads
Home   >   mailing lists

Thread: Best replication options

Best replication options

From
steven_c_job@yahoo.com (Steven job)
Date:
What is the best replication option out there today for postgresql.
Have been trying to get rserv working and that hasn't been the
easiest.

Would like to run 7.4.1.

Any suggestions?

-Steve

Re: Best replication options

From
Andrew Sullivan
Date:
On Sat, Feb 14, 2004 at 03:38:04PM -0800, Steven job wrote:
> What is the best replication option out there today for postgresql.
> Have been trying to get rserv working and that hasn't been the
> easiest.

rserv doesn't work with 7.4 AFAIK.  erserver seems to; I haven't
actually used it in production, although I'm about to.  dbmirror has
had reports of success.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
                --Brad Holland

Re: Best replication options

From
"Marc G. Fournier"
Date:
On Wed, 18 Feb 2004, Andrew Sullivan wrote:

> On Sat, Feb 14, 2004 at 03:38:04PM -0800, Steven job wrote:
> > What is the best replication option out there today for postgresql.
> > Have been trying to get rserv working and that hasn't been the
> > easiest.
>
> rserv doesn't work with 7.4 AFAIK.  erserver seems to; I haven't
> actually used it in production, although I'm about to.  dbmirror has
> had reports of success.

We have several clients running erserver w/ 7.4, with another deploying
this coming weekend, and haven't had any reports of problems ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: Best replication options

From
"Joshua D. Drake"
Date:
>>rserv doesn't work with 7.4 AFAIK.  erserver seems to; I haven't
>>actually used it in production, although I'm about to.  dbmirror has
>>had reports of success.
>
>
> We have several clients running erserver w/ 7.4, with another deploying
> this coming weekend, and haven't had any reports of problems ...
>

We (Command Prompt) also have several large database clients using
PostgreSQL Replicator. On both 7.4.x and 7.3.x.

Sincerely,

Joshua D. Drake





> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
Attachment