problem running postmaster

[pw]

Hello,

I am having problems running postmaster.
I get the following error:

DEBUG: invoking IpcMemoryCreate(size=1466368)
PANIC: invalid checksum in control file
The postmaster then exits.

What control file is it talking about?
Is this a common error?

Thanks for any help

Peter
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Shridhar Daithankar]

pw wrote:

Hello,

I am having problems running postmaster.
I get the following error:

DEBUG: invoking IpcMemoryCreate(size=1466368)
PANIC: invalid checksum in control file
$PGDATA/pg_clog

Control files reside in there

The postmaster then exits.

What control file is it talking about?
Is this a common error?

No this is not common. Was there a hard system crash and psotgresql data reside
on a non-journalling file system?

If yes, you are looking at an inconsistent database.

Please confirm.

Shridhar
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

"pw" <p.******@telus.net> writes:

PANIC: invalid checksum in control file What control file is it talking about?
$PGDATA/global/pg_control
Is this a common error?

No; I don't think I've ever seen it reported from the field before.
How did you get into this state?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match