Re: debug issue on postgresql

[Guillaume Lelarge <guillaume(at)lelarge(dot)info>]

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