Re: 2 computers 1hd 2 postgres daemons. Is it possible?]

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Marc Rassbach <marc(at)milestonerdl(dot)com>
Cc: Adam Lang <aalang(at)rutgersinsurance(dot)com>, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: 2 computers 1hd 2 postgres daemons. Is it possible?]
Date: 2000-10-18 01:14:02
Message-ID: 39ECF95A.9C11F434@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I guess you missed the announcement. This *is* coming to postgres, but
I'm unclear if it is going to be included or it will be a seperate
package.

Marc Rassbach wrote:
>
> And there DOES come a time where PostgreSQL is not the correct solution.
>
> At this time you can not mirror a postgreSQL server like you can mirror a,
> say Oracle server. It sounds like they want mirroring servers the way
> some commerical servers can do.
>
> Nothing stopping your employer/patron/slave driver from paying someone to
> develop this kind of feature in postgreSQL.
>
> And nothing stopping you from re-writting the app such that the app
> worries about mirroring the data. (IE, it makes sure it has its own
> transaction set in case it can't talk to the other server, and all queries
> are duplicated on the other box.)
>
>
> On Tue, 17 Oct 2000, Adam Lang wrote:
>
> > Granted it probably not the most efficient solution, but if it is something
> > that is really a problem... what about having your dual server, one data
> > source setup, but the second server is idle and does nothing and only kicks
> > in if the primary drops? Might be more complicated to setup than it sounds
> > and there still would be a time delay for the second to pick up, but it
> > technically would eliminate the two servers butting heads. Again though,
> > not very efficient solution... unless it is very critical and money is no
> > object. :)
> >
> > Adam Lang
> > Systems Engineer
> > Rutgers Casualty Insurance Company
> > ----- Original Message -----
> > From: "Joseph Shraibman" <jks(at)selectacast(dot)net>
> > To: <pgsql-interfaces(at)postgreSQL(dot)org>
> > Sent: Tuesday, October 17, 2000 2:53 PM
> > Subject: [Fwd: [INTERFACES] 2 computers 1hd 2 postgres daemons. Is it
> > possible?]
> >
> >
> > >
> > > --
> > > Joseph Shraibman
> > > jks(at)selectacast(dot)net
> > > Increase signal to noise ratio. http://www.targabot.com
> >
> >

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-10-18 08:29:32 RE: Interrupted system call and JDBC
Previous Message Marc Rassbach 2000-10-17 23:54:34 Re: 2 computers 1hd 2 postgres daemons. Is it possible?]