Re: 1 cluster on several servers

I'll take that as a "no".
What i mean is to actually run exactly one cluster (no replicated copy) on
more than one server. Of course, if that were possible, why would people
bother with replication..

I guess it is irrational to suggest that it would be possible, since each
server would at least need to have it's own copy of the DBMS software etc,
or it would cease to be a separate server.

Maybe "Data Partitioning", as in the documentation link Shane sent, possibly
combined with Slony for the other data per server, would be an option for
me.

Is there an implementation for this in PostgreSQL? It would have to be
something like pgPool (middleware), because: How would the query know on
which server to put it's data? And i guess i would need some Kerberos-like
implementation for my authentication and authorization...

cheers,

WBL

On Nov 29, 2007 1:23 PM, Shane Ambler <pgsql(at)sheeky(dot)biz> wrote:

> Willy-Bas Loos wrote:
> > Hi,
> >
> > Is it possible to run one PostgreSQL cluster on more than one (hardware)
> > server?
> >
> > WBL
> >
> You would be looking for replication.
> Start with
> http://www.postgresql.org/docs/8.2/interactive/high-availability.html
> to get some idea on what is available for what you wish to achieve.
> Some of the projects that add these features are mentioned.
>
>
>
>
> --
>
> Shane Ambler
> pgSQL(at)Sheeky(dot)Biz
>
> Get Sheeky @ http://Sheeky.Biz
>