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@xxxxxxxxxxxxxx> 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
