Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6F5049FC0BD for ; Thu, 28 Jun 2007 06:37:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 00789-06 for ; Thu, 28 Jun 2007 06:37:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id 80CD99FC0A5 for ; Thu, 28 Jun 2007 06:37:41 -0300 (ADT) Received: (qmail 7658 invoked by uid 540); 28 Jun 2007 09:38:06 -0000 Received: from 217.149.240.98 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(217.149.240.98):. Processed in 0.090161 secs); 28 Jun 2007 09:38:06 -0000 Received: from rzgw1.artnet.pl (HELO FSAdam.rzgw.gda) (informatyka-adamr@217.149.240.98) by ns1.peker.com.pl with SMTP; 28 Jun 2007 09:38:06 -0000 Message-ID: <46838060.8040803@informatyka.gdansk.pl> Date: Thu, 28 Jun 2007 11:33:20 +0200 From: Adam Radlowski User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: POLONKAI Gergely CC: pgsql-admin@postgresql.org Subject: Re: Distributed database with PostgreSQL References: <468372D8.5050104@w00d5t0ck.info> <9e4684ce0706280142r1100326ey473a6b48c0714e09@mail.gmail.com> <4683786A.5070608@w00d5t0ck.info> In-Reply-To: <4683786A.5070608@w00d5t0ck.info> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/286 X-Sequence-Number: 25954 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 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 > > >