Fw: Fw: postgresql in cluster of servers - Mailing list pgsql-performance

From enediel
Subject Fw: Fw: postgresql in cluster of servers
Date
Msg-id 006f01c2b81f$89508e10$8a24a8c0@nsoft
Whole thread Raw
Responses Re: Fw: Fw: postgresql in cluster of servers  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
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" <pginfo@t1.unisoftbg.com>
To: "enediel" <enediel@com.ith.tur.cu>
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" <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)
>


pgsql-performance by date:

Previous
From: pginfo
Date:
Subject: Re: Fw: postgresql in cluster of servers
Next
From: "scott.marlowe"
Date:
Subject: Re: Fw: Fw: postgresql in cluster of servers