On Nov 29, 2007 6:27 PM, Willy-Bas Loos <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > > > Get Sheeky @ http://Sheeky.Biz > > > > -- Usama Munir Dar http://linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar
