Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A1D36476115 for ; Thu, 9 Jan 2003 12:40:14 -0500 (EST) Received: from com.ith.tur.cu (com.ith.tur.cu [212.44.111.34]) by postgresql.org (Postfix) with ESMTP id 1020D476085 for ; Thu, 9 Jan 2003 12:40:11 -0500 (EST) Received: from nsoft by com.ith.tur.cu with SMTP (MDaemon.PRO.v6.0.7.R) for ; Thu, 09 Jan 2003 12:42:01 -0500 Message-ID: <006f01c2b81f$89508e10$8a24a8c0@nsoft> Reply-To: "enediel" From: "enediel" To: "postgresql" Subject: Fw: Fw: postgresql in cluster of servers Date: Thu, 9 Jan 2003 12:41:44 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Return-Path: enediel@com.ith.tur.cu X-MDaemon-Deliver-To: pgsql-performance@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/68 X-Sequence-Number: 715 No, pginfo, suposse this example Web server or cluster web server, it's unimportant | Postgresql cluster server containing{ ... Real server 1 running postgresql processes Real server 2 running postgresql processes .... } | File server machine that contains all pg_databases Notice that the real servers don't have in their hard disk any database, they could have a link to the hard disk in the File server machine. The syncronization between postgresql processes that are running on different machines and using the same database is my question. Thanks for the answer Greetings Enediel Linux user 300141 Happy who can penetrate the secret causes of the things ĦUse Linux! ----- Original Message ----- From: "pginfo" To: "enediel" Sent: Thursday, January 09, 2003 8:21 AM Subject: Re: Fw: [PERFORM] postgresql in cluster of servers > Hi, > > I think if we speak about single db server you will nead to ask > the app. server provider about clustering. > > I am working with jboss and it is supporting clustering. > > > regards, > ivan. > > 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? > > > > Greetings > > Enediel > > Linux user 300141 > > > > 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 | > > > +------------------------------------------------------------+ > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >