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 по дате отправления: