Re: data replication

From: Justin Clift <justin(at)postgresql(dot)org>
To: Gyorgy Molnar <yuri(at)powercom(dot)com(dot)sg>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: data replication
Date: 2002-10-02 04:21:56
Message-ID: 3D9A7464.13077315@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Yuri,

There are a couple of approaches in existence already:

Free/Open Source
++++++++++++++++

PostgreSQL Replicator
http://pgreplicator.sourceforge.net

Usogres
http://usogres.good-day.net

The pgreplication Project
http://gborg.postgresql.org/project/pgreplication/projdisplay.php

Commercial
++++++++++

eRserver
http://www.pgsql.com

Of these, the eRserver approach works well (have been doing stuff with
it recently in master to multi-slave async configurations), and the
pgreplication project should have some interesting stuff ready for
testing pretty soon.

Hope that helps.

:-)

Regards and best wishes,

Justin Clift

Gyorgy Molnar wrote:
>
> Hello,
>
> I'm wondering if it's possible to create a slave server where the data is
> continuously replicated?
>
> Kind Regards,
> Yuri
>
> ---------------------------(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)

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-10-02 04:22:36 Re: database session variables
Previous Message Justin Clift 2002-10-02 03:27:11 Re: PostgreSQL Website : advocacy.postgresql.org