Re: SR fails to send existing WAL file after off-line copy

Heikki Linnakangas wrote:
> Yes, indeed there is a corner-case bug when you try to stream the very 
> first WAL segment, with log==seg==0.

I confirmed that the bug exists in only this case by taking my problem 
install and doing this:

psql -d postgres -c "checkpoint; select pg_switch_xlog();"

To force it to the next xlog file.  With only that change, everything 
else then works.  So we'll just need to warn people about this issue and 
provide that workaround, as something that only trivial new installs 
without much data loaded into them are likely to run into, until 9.0.2 
ships with your fix in it.  I'll update the docs on the wiki 
accordingly, once I've recovered from this morning's flight out West.

I forgot to credit Robert Noles here for rediscovering this bug on one 
of our systems and bringing it to my attention.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services and Support        www.2ndQuadrant.us