Message-ID: <4824841F.4020104@lelarge.info>
Date: Fri, 09 May 2008 19:04:31 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Thunderbird 2.0.0.14 (X11/20080505)
MIME-Version: 1.0
To: "MARIOTTI, Alessandro \(Alessandro\)" <mariotti@alcatel-lucent.com>
CC: pgsql-admin@postgresql.org
Subject: Re: debug issue on postgresql
References: <85618CB6B1C0F14D888609DB41641AB40127F1EA@DEEXC1U03.de.lucent.com>
In-Reply-To: 
 <85618CB6B1C0F14D888609DB41641AB40127F1EA@DEEXC1U03.de.lucent.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

MARIOTTI, Alessandro (Alessandro) a écrit :
> I’m writing you to get some information regarding the possibility to get 
> some information a db corruption got yesterday morning in a live platform .
> 
> We realized DB Inconsistence and corruption and we tried to restore 
> immediately the DB , via a back-up procedure, to restore services for 
> customer.
> 
> Now we need to investigate on DB what it was the route cause for db 
> corruption.
> 

Do you have a backup of the corrupted database ? If you don't, it will 
be extremely hard to tell you anything interesting.

And you need to tell us what kind of issue you have, which release you 
use, etc.

> Unfortunately we don’t have any experience with postgres db because the 
> platform had improved by a colleague that left company and no one got 
> the opportunity to learn something …..
> 
> Some documentation to start with postgres will be appreciate .
> 

http://www.postgresql.org/docs/ and then choose the manual related to 
your PostgreSQL release.

Regards.


-- 
Guillaume.
  http://www.postgresqlfr.org
  http://dalibo.com