Re: WAL status update - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: WAL status update
Date
Msg-id Pine.LNX.4.21.0010312322300.1073-100000@peter.localdomain
Whole thread Raw
List pgsql-hackers
Vadim Mikheev writes:

> WAL with rollforward logic is available for testing but yet requires
> re-compiling with -DXLOG flag. Note that regress tests are passed but
> it doesn't mean anything. What is required is testing how recovery
> does work (just run pg_ctl -m i stop after some changes in db and test
> db after restart). Also, I've tested it for single running transaction
> only. xlog.c:XLOG_DEBUG is on currently and results in high output to
> stderr.

The first test did not go very well.  I did a fresh compile, initdb,
started the postmaster, ran 'make installcheck' (sequential regression
tests), and sent a kill -QUIT to the postmaster during the numeric test.
Then I restarted the postmaster and got a load of lines like

REDO @ 0/434072; LSN 0/434100: prev 0/433992; xprev 0/433992; xid
17278: Transaction - commit: 2000-10-31 23:21:29
REDO @ 0/434100; LSN 0/434252: prev 0/434072; xprev 0/0; xid 17279: Heap -
insert: node 19008/1259; cid 0; tid 1/43

after which it finished with

Startup failed - abort

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-hackers by date:

Previous
From: "Jones, Colin"
Date:
Subject: RE: Restricting permissions on Unix socket
Next
From: Alfred Perlstein
Date:
Subject: Re: [GENERAL] Query caching