| From: | "L(dot)Boldareva" <pg(at)pierro(dot)dds(dot)nl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: How to recover when can't start database |
| Date: | 2005-04-01 16:19:04 |
| Message-ID: | Pine.LNX.4.58.0504011811520.19842@yafa.dds.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 1 Apr 2005, Tom Lane wrote:
> "L.Boldareva" <pg(at)pierro(dot)dds(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris White (cjwhite) | 2005-04-01 19:40:29 | Help understanding VACUUM info on 7.4.5 |
| Previous Message | Tom Lane | 2005-04-01 16:10:05 | Re: How to recover when can't start database |