Re: How to recover when can't start database

Поиск
Список
Период
Сортировка
От L.Boldareva
Тема Re: How to recover when can't start database
Дата
Msg-id Pine.LNX.4.58.0504011811520.19842@yafa.dds.nl
обсуждение исходный текст
Ответ на Re: How to recover when can't start database  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Fri, 1 Apr 2005, Tom Lane wrote:

> "L.Boldareva" <pg@pierro.dds.nl> writes:
> > Here is how I got it crashed:
> > I compiled a c-procedure and copied the .so file to its place exactly at a
> > time when (quite unfortunately) another query was running, that used that
> > library.
>

> Hmm, at worst that should only crash one backend, not result in bad data
> getting into the WAL log.  If there was no filesystem crash then I have
> to suppose that the page number entered in the WAL page split record was
> wrong ... but how could that happen if the same page number had just
> been used successfully to read the page?
>
>             regards, tom lane

I have no idea
Tell me where to look, I'll have a look in the tar. I'd
rather not reproduce the thing, but if someone is interested, I can try
that, too (later).

regards,
LB

>

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to recover when can't start database
Следующее
От: "Chris White (cjwhite)"
Дата:
Сообщение: Help understanding VACUUM info on 7.4.5