Thread: Fw: postgresql in cluster of servers

Fw: postgresql in cluster of servers

From
"enediel"
Date:
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
>


Re: Fw: postgresql in cluster of servers

From
Ron Johnson
Date:
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                                 |
+------------------------------------------------------------+


Re: Fw: postgresql in cluster of servers

From
pginfo
Date:
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)