Re: How to recover when can't start database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "L(dot)Boldareva" <pg(at)pierro(dot)dds(dot)nl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to recover when can't start database
Date: 2005-04-01 16:10:05
Message-ID: 6883.1112371805@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message L.Boldareva 2005-04-01 16:19:04 Re: How to recover when can't start database
Previous Message L.Boldareva 2005-04-01 15:57:55 Re: How to recover when can't start database