Thread: Invalid Checksum in Control File

Invalid Checksum in Control File

From
"Christopher Bland"
Date:
We recently had a system failure and needed to rebuild a server. Our
database is stored in a storage array and after the rebuild my service
fails with pglog reporting:

FATAL:  incorrect checksum in control file

I've read that the control file is saved in pg_clog however I have not
been able to find out how to recover from this error. We're running FC6
and Postgres 8.1.4. Any input would be greatly appreciated.

Thanks,
Chris


________________________________________________________________________
FREE Reminder Service  - NEW from AmericanGreetings.com
Click HERE and never forget a Birthday or Anniversary again!
http://track.juno.com/s/lc?s=197335&u=http://www.americangreetings.com/products/online_calendar.pd?c=uol5752



Re: Invalid Checksum in Control File

From
Tom Lane
Date:
"Christopher Bland" <themanatuf@juno.com> writes:
> FATAL:  incorrect checksum in control file

Does pg_controldata print anything useful?

            regards, tom lane

Re: Invalid Checksum in Control File

From
"Christopher Bland"
Date:
>> "Christopher Bland" <themanatuf@juno.com> writes:
>> FATAL:  incorrect checksum in control file
>
>Does pg_controldata print anything useful?
>
>            regards, tom lane

I *just* re-initialized the database and started over. I didn't think I had a dump of the original
but then I found it. Thanks for replying.

Chris


________________________________________________________________________
FREE Reminder Service  - NEW from AmericanGreetings.com
Click HERE and never forget a Birthday or Anniversary again!
http://track.juno.com/s/lc?s=197335&u=http://www.americangreetings.com/products/online_calendar.pd?c=uol5752