Re: 1 cluster on several servers

On Nov 29, 2007 6:27 PM, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:

> 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...
>

There used to be parallel server type solution for postgresql called ExtenDB
www.extendb.com , but i think its now acquired by a commercial PostgresSQL
vendor, but i have seen others similar to that.

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

--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar