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

Re: Distributed database with PostgreSQL

From: Adam Radlowski <adamr(at)informatyka(dot)gdansk(dot)pl>
To: POLONKAI Gergely <polesz(at)w00d5t0ck(dot)info>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Distributed database with PostgreSQL
Date: 2007-06-28 09:33:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Some ideas:
With Slony one the one of these server You can install paralell a 
"central" database and "slave". They can work on two database clusters 
with running two PostgreSQL instances (on two different ports).
Read the docs about dbmirror too (source tree - contrib/dbmirror).
You can make Your own replication using the module dblink (If You are 
using PostgreSQL compiled from sources, You have to change directory in 
source tree to contrib/dblink; read there all docs, compile and install; 
You have to remember to run script dblink.sql calling it from psql after 
"make install").

POLONKAI Gergely pisze:
> hubert depesz lubaczewski írta:
>> On 6/28/07, POLONKAI Gergely <polesz(at)w00d5t0ck(dot)info> wrote:
>>> keywords), I ask here: is it possible to run one database on multiple
>>> servers, so all the nodes would see the same data?
>> what you're asking is replication, and i belive that if you do a simple
>> search on "postgresql replication" it will return a lot of results.
>> basic choice for postgresql replication is slony, but there are other
>> (both
>> free and proprietary) options.
>> depesz
> Actually, it is not replication we need, as all the nodes are equal, so
> there is no master server at all. I'm googling around now with these
> keywords tho, but I think this is not we need...
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?

In response to

pgsql-admin by date

Next:From: hubert depesz lubaczewskiDate: 2007-06-28 10:20:18
Subject: Re: Distributed database with PostgreSQL
Previous:From: POLONKAI GergelyDate: 2007-06-28 08:59:22
Subject: Re: Distributed database with PostgreSQL

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