[GENERAL] Recovering database after disk crash

2008-05-12 Thread Vic Simkus
Hello A disk hosting an instance of 8.2 crashed on me (hardware failure). I was able to pull most of the data off the drive, but the one database that I need the most is corrupt. I'm not really sure where to start... so here are some error messages: [EMAIL PROTECTED]:/var/log/postgresql$ pg_dum

Re: [GENERAL] Recovering database after disk crash

2008-05-12 Thread Vic Simkus
After doing some more reading I've come to the conclusion that I'm in completely over my head. I got a fresh copy of the corrupt data and am starting from the very beginning. Here's the error I get on startup: [EMAIL PROTECTED]:/usr/lib/postgresql/8.2/bin$ ./postgres -D /var/lib/postgresql/8.2/

Re: [GENERAL] Recovering database after disk crash

2008-05-12 Thread Vic Simkus
I can probably piece everything together enough to get the data out. Does that make sense or am I off my rocker? On 5/12/08, Tom Lane <[EMAIL PROTECTED]> wrote: > "Vic Simkus" <[EMAIL PROTECTED]> writes: > > [EMAIL PROTECTED]:/var/log/postgresql$ reindexdb EPC > &g

Re: [GENERAL] Recovering database after disk crash

2008-05-12 Thread Vic Simkus
es anyways? :) On 5/12/08, Tom Lane <[EMAIL PROTECTED]> wrote: > "Vic Simkus" <[EMAIL PROTECTED]> writes: > > If I'm understanding the errors correctly it seems that the corruption > > is in the system catalogs (metadata). The database does not use any >