Re: [HACKERS] Replication documentation addition

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: josh(at)agliodbs(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: [HACKERS] Replication documentation addition
Date: 2006-10-24 19:23:06
Message-ID: 453E681A.3000004@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

Hello Josh,

Josh Berkus wrote:
> Hmmm ... while the primer on different types of replication is fine, I
> think what users were really looking for is a listing of the different
> replication solutions which are available for PostgreSQL and how to get
> them.

Well, let's see what we have:

* Shared Disk Fail Over
* Warm Standby Using Point-In-Time Recovery
* Point-In-Time Recovery

these first three require quite some configuration, AFAIK there is no
tool or single solution you can download, install and be happy with. I
probably wouldn't even call them 'replication solutions'. For me those
are more like backups with fail-over capability.

* Continuously Running Fail-Over Server

(BTW, what is 'partial replication' supposed to mean here?)
Here we could link to Slony.

* Data Partitioning

Here we can't provide a link, it's just a way to handle the problem in
the application code.

* Query Broadcast Replication

Here we could link to PgPool.

* Multi-Master Replication
(or better: Distributed Shared Memory Replication)

No existing solution for PostgreSQL.

Looking at that, I'm a) missing PgCluster and b) arguing that we have to
admit that we simply can not 'list .. replication solutions ... and how
to get them' because all of the solutions mentioned need quite some
knowledge and require a more or less complex installation and configuration.

Regards

Markus

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Joshua D. Drake 2006-10-24 19:34:17 Re: [HACKERS] Replication documentation addition
Previous Message Josh Berkus 2006-10-24 18:37:46 Re: [HACKERS] Replication documentation addition

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2006-10-24 19:34:17 Re: [HACKERS] Replication documentation addition
Previous Message Andrew Sullivan 2006-10-24 19:00:34 Re: Conference materials (Was: [HACKERS] pdfs of