pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedInvalid Checksum in Control File
3+ messages / 2 participants
[nested] [flat]
* Invalid Checksum in Control File
@ 2007-01-11 16:46 Christopher Bland <themanatuf@juno.com>
0 siblings, 1 reply; 3+ messages in thread
From: Christopher Bland @ 2007-01-11 16:46 UTC (permalink / raw)
To: pgsql-admin
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....
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Invalid Checksum in Control File
@ 2007-01-11 17:38 Tom Lane <tgl@sss.pgh.pa.us>
parent: Christopher Bland <themanatuf@juno.com>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2007-01-11 17:38 UTC (permalink / raw)
To: Christopher Bland <themanatuf@juno.com>; +Cc: pgsql-admin
"Christopher Bland" <themanatuf@juno.com> writes:
> FATAL: incorrect checksum in control file
Does pg_controldata print anything useful?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Invalid Checksum in Control File
@ 2007-01-15 18:27 Christopher Bland <themanatuf@juno.com>
0 siblings, 0 replies; 3+ messages in thread
From: Christopher Bland @ 2007-01-15 18:27 UTC (permalink / raw)
To: tgl@sss.pgh.pa.us; +Cc: pgsql-admin
>> "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....
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-01-15 18:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-11 16:46 Invalid Checksum in Control File Christopher Bland <themanatuf@juno.com>
2007-01-11 17:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-01-15 18:27 Re: Invalid Checksum in Control File Christopher Bland <themanatuf@juno.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox