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$
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
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
NOTICE: table pg_class was reindexed
reindexdb
? :)
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
fancy datatypes. Is there any way for me to rebuild the metadata