pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adam Radlowski <adamr@informatyka.gdansk.pl>
To: POLONKAI Gergely <polesz@w00d5t0ck.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: Distributed database with PostgreSQL
Date: Thu, 28 Jun 2007 11:33:20 +0200
Message-ID: <46838060.8040803@informatyka.gdansk.pl> (raw)
In-Reply-To: <4683786A.5070608@w00d5t0ck.info>
References: <468372D8.5050104@w00d5t0ck.info>
	<9e4684ce0706280142r1100326ey473a6b48c0714e09@mail.gmail.com>
	<4683786A.5070608@w00d5t0ck.info>

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").
Adam

POLONKAI Gergely pisze:
> hubert depesz lubaczewski írta:
>   
>> On 6/28/07, POLONKAI Gergely <polesz@w00d5t0ck.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?
>
>                http://www.postgresql.org/docs/faq
>
>
>   




view thread (6+ messages)  latest in thread

Message-ID: <46838060.8040803@informatyka.gdansk.pl>
Permalink:  ../46838060.8040803@informatyka.gdansk.pl/
Also on:    postgresql.org/message-id/46838060.8040803@informatyka.gdansk.pl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: adamr@informatyka.gdansk.pl, polesz@w00d5t0ck.info
  Subject: Re: Distributed database with PostgreSQL
  In-Reply-To: <46838060.8040803@informatyka.gdansk.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox