Re: [ADMIN] How to recover when can't start database

2005-04-01 Thread L.Boldareva
On Fri, 1 Apr 2005, Tom Lane wrote: > "L.Boldareva" <[EMAIL PROTECTED]> 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, tha

Re: [ADMIN] How to recover when can't start database

2005-04-01 Thread L.Boldareva
I have kind of fixed the problem (hopefully) I turned out I used plan B, dump/reload will be my next step then. What is meant by the "corrupt data", is this about the data or the things around it, like indexes, system tables? Here is how I got it crashed: I compiled a c-procedure and copied the .

Re: [ADMIN] How to recover when can't start database

2005-04-01 Thread L.Boldareva
Ok, looks like I kind of fixed it. (after tarring data/) I ran pg_resetxlog -f , although it's not meant to fix this problem. The database starts up now, but the last created couple of tables are coppupted, so that it cannot be reindexed or vaccumed, and there is an error in a system table: Pos

[ADMIN] How to recover when can't start database

2005-04-01 Thread L.Boldareva
Hi! (Hope this is the right place to post) I crashed the postmaster and cannot start it anymore, with the error LOG: database system was interrupted while in recovery at 2005-04-01 11:04:33 CEST HINT: This probably means that some data is corrupted and you will have to use the last backup fo