Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0234F475E31 for ; Wed, 8 Jan 2003 18:38:55 -0500 (EST) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by postgresql.org (Postfix) with ESMTP id 5D2D0475D3B for ; Wed, 8 Jan 2003 18:38:54 -0500 (EST) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030108233856.ZRTS26808.lakemtao03.cox.net@[192.168.1.1]> for ; Wed, 8 Jan 2003 18:38:56 -0500 Subject: Re: Fw: postgresql in cluster of servers From: Ron Johnson To: postgresql In-Reply-To: <018901c2b781$5576d2f0$8a24a8c0@nsoft> References: <018901c2b781$5576d2f0$8a24a8c0@nsoft> Content-Type: text/plain; charset=ISO-8859-1 Organization: Message-Id: <1042069134.7864.205.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 08 Jan 2003 17:38:54 -0600 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/66 X-Sequence-Number: 713 On Wed, 2003-01-08 at 19:49, enediel wrote: > Thanks for all answers: > Ron Johnson, I mean the second option thet you wrote: > > (2) multiple application server machines all hitting a single database > sitting on a single database server machine? Ok, great. To the PG server, the app servers are db clients, just like any other client. Multi-user access, arranged so that users don't step over each other, is integrated deeply into the server. Thus, PostgreSQL meets this qualification... > Happy who can penetrate the secret causes of the things > ĦUse Linux! > ----- Original Message ----- > From: "Ron Johnson" > To: "postgresql" > Sent: Wednesday, January 08, 2003 1:14 PM > Subject: Re: [PERFORM] postgresql in cluster of servers > > > > On Wed, 2003-01-08 at 11:18, enediel wrote: > > > Hello to all list members: > > > > > > I'm looking for information about using postgresql in a cluster of > servers > > > where all real servers share a unique databases location outside them. > > > > > > The question could be one of the follows? > > > > > > ?Is the prostgresql prepared to synchronize simultaneous accesses to > oneself > > > database among processes that run in different PC's? > > > > > > or > > > > > > ?Was the postgresql database designed to allow simultaneous acceses of > > > processes that run in different PC's allowing for own design the > > > sincronizationof all the processes? > > > > To clarify: do you mean > > > > (1) multiple copies of *the*same*database* sitting on many machines, > > and all of them synchronizing themselves? > > > > OR > > > > (2) multiple application server machines all hitting a single database > > sitting on a single database server machine? -- +------------------------------------------------------------+ | Ron Johnson, Jr. mailto:ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | "Basically, I got on the plane with a bomb. Basically, I | | tried to ignite it. Basically, yeah, I intended to damage | | the plane." | | RICHARD REID, who tried to blow up American Airlines | | Flight 63 | +------------------------------------------------------------+