Skip site navigation (1) Skip section navigation (2)

Re: beta testing version

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: beta testing version
Date: 2000-12-01 21:28:10
Message-ID: 3.0.1.32.20001201132810.01712ac0@mail.pacifier.com (view raw or flat)
Thread:
Lists: pgsql-hackers
At 12:56 PM 12/1/00 -0800, Nathan Myers wrote:

>(Remember, we're talking about what you could do *now*, with 7.1.
>Presumably with 7.2 other options will open.)

Maybe *you* are :)  Seriously, I'm thinking out loud about future
possibilities.  Putting a lot of work into building up a temporary
solution on top of 7.1 doesn't make a lot of sense, anyone wanting
to work on such things ought to think about 7.2, which presumably will
beta sometime mid-2001 or so???

And I don't think there are 7.1 hacks that are simple ... could be
wrong, though.

>I don't know of any way to synchronously transfer the WAL, currently.

Nope.

>Anyway, I would expect doing it to interfere seriously with performance.

Yep.  Anyone here have experience with replication and Oracle or others?
I've heard from one source that setting it up reliabily in Oracle and
getting the switch from the dead to the backup server working properly was
something of a DBA nightmare, but that's true of just about anything in
Oracle.  Once it was up, it worked reliably, though (also typical
of Oracle).

>The "wait to log a 'commit' locally until after the remote site acks that
>it got the WAL" is (akin to) the familiar two-phase commit.

Right.



- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-12-01 22:07:42
Subject: Re: Rules with Conditions: Bug, or Misunderstanding
Previous:From: Joel BurtonDate: 2000-12-01 21:03:46
Subject: Re: Rules with Conditions: Bug, or Misunderstanding

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group