Skip site navigation (1) Skip section navigation (2)

Re: Problems starting up postgres

From: Denis Perchine <dyp(at)perchine(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problems starting up postgres
Date: 2001-09-06 14:09:07
Message-ID: 20010906111051.B807E1FD74@mx.webmailstation.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thursday 06 September 2001 20:49, Tom Lane wrote: 
> Denis Perchine <dyp(at)perchine(dot)com> writes: 
> Okay.  As a temporary recovery measure, I'd suggest reducing that 
> particular elog from STOP to DEBUG level.  That will let you start up 
> and run the database.  You'll need to look through your tables and try 
> to figure out which one(s) have lost data.  It might be interesting to 
> try to figure out just which page has the bad LSN value --- that might 
> give us a clue why the WAL did not provide protection against this 
> failure.  Unfortunately XLogFlush doesn't have any idea who its caller 
> is, so the only way I can think of to check that directly is to set a 
> breakpoint at this error report and look at the call stack. 
 
OK. I will do this tomorrow. I have no space, and I forced to tgz, untgz 
database. 
 
--  
Sincerely Yours, 
Denis Perchine 
 
---------------------------------- 
E-Mail: dyp(at)perchine(dot)com 
HomePage: http://www.perchine.com/dyp/ 
FidoNet: 2:5000/120.5 
---------------------------------- 
 


In response to

pgsql-hackers by date

Next:From: Ken HirschDate: 2001-09-06 14:48:52
Subject: Re: Log rotation?
Previous:From: Matthew HagertyDate: 2001-09-06 14:08:21
Subject: Re: Log rotation?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group