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

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: SR fails to send existing WAL file after off-line copy
Дата
Msg-id 4CCFBD86.9090607@enterprisedb.com
обсуждение исходный текст
Ответ на Re: SR fails to send existing WAL file after off-line copy  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 02.11.2010 00:47, Tom Lane wrote:
> Greg Stark<gsstark@mit.edu>  writes:
>> On Mon, Nov 1, 2010 at 12:37 AM, Heikki Linnakangas
>> <heikki.linnakangas@enterprisedb.com>  wrote:
>>> Yes, indeed there is a corner-case bug when you try to stream the very first
>>> WAL segment, with log==seg==0.
>
>> This smells very much like
>> http://article.gmane.org/gmane.comp.db.postgresql.devel.general/137052
>
>> I wonder if there's some defensive programming way to avoid bugs of this sort.
>
> It strikes me that it's not good if there isn't a recognizable "invalid"
> value for WAL locations.  These bits of code show that there is reason
> to have one.  Maybe we should teach initdb to start the WAL one segment
> later, and then 0/0 *would* mean "invalid", and we could revert these
> other hacks.

Good idea. That can even be back-patched to 9.0, it should have no 
effect on existing installations,

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [PATCH] Custom code int(32|64) => text conversions out of performance reasons
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: B-tree parent pointer and checkpoints