pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Invalid 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