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

Re: production server down

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: production server down
Date: 2004-12-18 22:42:29
Message-ID: 200412182242.iBIMgTm24674@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Joe Conway wrote:
> We then spent most of the next 24 hours reviewing the recovered 
> database. The bulk data loading process was well instrumented, so we 
> knew exactly which data should have been committed prior to the server 
> hang, and which files were inprocess (we had been doing 10 loads in 
> parallel) at the time of the hang. The results of the investigation 
> indicated complete recovery, with no missing or unwanted (i.e. 
> uncommitted records looking committed) data.

Good analysis.  Seems you were lucky in that only WAL was corrupt and
not the heap or index files.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Tatsuo IshiiDate: 2004-12-18 23:24:59
Subject: Re: Call for port reports
Previous:From: Joe ConwayDate: 2004-12-18 22:28:51
Subject: Re: production server down

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