pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: enediel <enediel@com.ith.tur.cu>
To: postgresql <pgsql-performance@postgresql.org>
Subject: Fw: Fw: postgresql in cluster of servers
Date: Thu, 9 Jan 2003 12:41:44 -0800
Message-ID: <006f01c2b81f$89508e10$8a24a8c0@nsoft> (raw)

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)
>




view thread (9+ messages)  latest in thread

Message-ID: <006f01c2b81f$89508e10$8a24a8c0@nsoft>
Permalink:  ../006f01c2b81f$89508e10$8a24a8c0@nsoft/
Also on:    postgresql.org/message-id/006f01c2b81f$89508e10$8a24a8c0@nsoft

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: enediel@com.ith.tur.cu
  Subject: Re: Fw: Fw: postgresql in cluster of servers
  In-Reply-To: <006f01c2b81f$89508e10$8a24a8c0@nsoft>
  References: <006f01c2b81f$89508e10$8a24a8c0@nsoft>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox