Re: [GENERAL] 1 cluster on several servers

2007-12-04 Thread Raymond O'Donnell
On 02/12/2007 13:02, Michelle Konzack wrote: with 42 PostgreSQL servers of each 1,8 TByte. Wow! Who ever said size wasn't everything :-) Would you be willing to tell us a little about your hardware and software set-up? Also, are the servers running separate databases? - or is it one w

Re: [GENERAL] 1 cluster on several servers

2007-12-04 Thread Michelle Konzack
Am 2007-11-29 12:50:58, schrieb Willy-Bas Loos: > Hi, > > Is it possible to run one PostgreSQL cluster on more than one (hardware) > server? Yes of course... I run at a customer "Monster" with 42 PostgreSQL servers of each 1,8 TByte. Thanks, Greetings and nice Day Michelle Konzack Tamay

Re: [GENERAL] 1 cluster on several servers

2007-11-30 Thread Shane Ambler
Willy-Bas Loos 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.. What you may be thinking of is having several machines running postgres

Re: [GENERAL] 1 cluster on several servers

2007-11-29 Thread Willy-Bas Loos
This is the system i am talking about: http://people.planetpostgresql.org/xzilla/index.php?/archives/326-Solving-the-big-science-checklist.html There are many parties involved, and i am trying to figure out what configuration would be ideal for ours. On Nov 29, 2007 3:20 PM, Geoffrey <[EMAIL PROT

Re: [GENERAL] 1 cluster on several servers

2007-11-29 Thread Usama Dar
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 irrat

Re: [GENERAL] 1 cluster on several servers

2007-11-29 Thread Geoffrey
Willy-Bas Loos 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

Re: [GENERAL] 1 cluster on several servers

2007-11-29 Thread Richard Huxton
Willy-Bas Loos wrote: 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.

Re: [GENERAL] 1 cluster on several servers

2007-11-29 Thread Willy-Bas Loos
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 ne

Re: [GENERAL] 1 cluster on several servers

2007-11-29 Thread Shane Ambler
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 achi

[GENERAL] 1 cluster on several servers

2007-11-29 Thread Willy-Bas Loos
Hi, Is it possible to run one PostgreSQL cluster on more than one (hardware) server? WBL