Re: debug issue on postgresql

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