Обсуждение: Fw: postgresql in cluster of servers
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" <ron.l.johnson@cox.net> To: "postgresql" <pgsql-performance@postgresql.org> 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 >
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" <ron.l.johnson@cox.net> > To: "postgresql" <pgsql-performance@postgresql.org> > 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 | +------------------------------------------------------------+
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" <ron.l.johnson@cox.net> > To: "postgresql" <pgsql-performance@postgresql.org> > 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)