Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-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

pgsql-docs by date

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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group