Re: 2-phase commit - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re: 2-phase commit
Date
Msg-id 20030929164233.GG23542@libertyrms.info
Whole thread Raw
In response to Re: 2-phase commit  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-hackers
On Sun, Sep 28, 2003 at 11:58:24AM -0700, Kevin Brown wrote:
> > But the postmaster doesn't connect to any database, and in a serious
> > failure, might not be able to start one.
> 
> Ah, true.  But I figured that in the context of 2PC and replication that
> most of the associated failures were likely to occur in an active
> backend or something equivalent, where a stored procedure was likely to
> be accessible.

AS you go on to note, that's not always a possibility.  For instance,
server C crashes and can't come back because, say, its WAL is
scrabled.  All it will currently be able to do is scream at you in
the logs, which won't solve all the problems one has with 2PC (among
other problems).

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8                                        +1 416 646 3304
x110



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 2-phase commit
Next
From: Bruce Momjian
Date:
Subject: Re: 2-phase commit