postgres will not start up - corrupted on restart

From: Nicholas Wilson <nwilson5(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: postgres will not start up - corrupted on restart
Date: 2012-02-24 21:32:35
Message-ID: CABgBcYNSNqDbqzr5R1w-rQqhFGG1QGz+yig02MtsB+5FEEBLqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm running postgresql 9.0.
I was running several processes and did "sudo service postgres restart" and
it has thrown a fit.

2012-02-24 12:45:13 PST:[local]:[unknown](at)[unknown]:[16969]: LOG:
incomplete startup packet
2012-02-24 12:45:13 PST::@:[16968]: LOG: database system was not properly
shut down; automatic recovery in progress
2012-02-24 12:45:13 PST::@:[16968]: LOG: consistent recovery state reached
at 35E/C009D2B0
2012-02-24 12:45:13 PST::@:[16968]: LOG: redo starts at 35E/8503C678
2012-02-24 12:45:13 PST::@:[16968]: PANIC: GIN metapage disappeared
2012-02-24 12:45:13 PST::@:[16968]: CONTEXT: xlog redo Update metapage,
node: 1663/16558714/114537692 blkno: 85
2012-02-24 12:45:13 PST::@:[16967]: LOG: startup process (PID 16968) was
terminated by signal 6: Aborted
2012-02-24 12:45:13 PST::@:[16967]: LOG: aborting startup due to startup
process failure

Not sure if anyone can point me in the right direction. I didn't install
the server but I'm one of the people who uses it extensively. But I broke
it and now I need to fix it...

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2012-02-24 22:17:58 Re: Sanitizing text being stored in text fields - some characters cause problems
Previous Message Tanstaafl 2012-02-24 21:14:29 Re: Sanitizing text being stored in text fields - some characters cause problems