[ADMIN] Detecting DB corruption

2012-10-31 Thread Raj Gandhi
I'm looking for ways to detect DB index and any other type of corruption in DB. It looks like there is no tool to verify if Postgres DB is corrupted or not. I would like to detect some of the following DB corruptions: - corruption in DB indexes - detect duplicate primary keys in a table (noti

Re: [ADMIN] Detecting DB corruption

2012-11-01 Thread Raj Gandhi
Re-sending to correct addresses. >>Seriously, if you're facing DB corruption then something is already >>horribly wrong with your setup. >"Horribly" is not strong enough a word IMHO when we're discussing double primary key values... except if Raj is not using sequences to generate them. Although