Обсуждение: Re: pg_subtrans and WAL

Поиск
Список
Период
Сортировка

Re: pg_subtrans and WAL

От
Alvaro Herrera Munoz
Дата:
On Tue, Aug 10, 2004 at 12:24:06PM -0400, Tom Lane wrote:
> My discovery last night of a WAL synchronization error in pg_clog led me
> to take a look at pg_subtrans too.  I soon realized that in fact we are
> not WAL-logging pg_subtrans updates at all: subtransaction start sets up
> a pg_subtrans entry but makes no WAL entry for this action.
> 
> Seems like this is a problem.

Rats :-(

You are probably right.  In fact this was on my todo list and I overlooked
it -- it was mentioned during early discussion.

Right now I am heading to Bolivia for a conference, so I am not able to
do anything codewise right now, and I'll most likely have very intermitent
connection ...  I'll be back on monday 16.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)


Re: pg_subtrans and WAL

От
Bruce Momjian
Дата:
Added to open items:
* determine proper crash recovery/logging for pg_subtrans


---------------------------------------------------------------------------

Alvaro Herrera Munoz wrote:
> On Tue, Aug 10, 2004 at 12:24:06PM -0400, Tom Lane wrote:
> > My discovery last night of a WAL synchronization error in pg_clog led me
> > to take a look at pg_subtrans too.  I soon realized that in fact we are
> > not WAL-logging pg_subtrans updates at all: subtransaction start sets up
> > a pg_subtrans entry but makes no WAL entry for this action.
> > 
> > Seems like this is a problem.
> 
> Rats :-(
> 
> You are probably right.  In fact this was on my todo list and I overlooked
> it -- it was mentioned during early discussion.
> 
> Right now I am heading to Bolivia for a conference, so I am not able to
> do anything codewise right now, and I'll most likely have very intermitent
> connection ...  I'll be back on monday 16.
> 
> -- 
> Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
> "Estoy de acuerdo contigo en que la verdad absoluta no existe...
> El problema es que la mentira s? existe y tu est?s mintiendo" (G. Lama)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073