problem running postmaster

pw wrote:
[color=blue]
> Hello,
>
> I am having problems running postmaster.
> I get the following error:
>
> DEBUG: invoking IpcMemoryCreate(size=1466368)
> PANIC: invalid checksum in control file[/color]

$PGDATA/pg_clog

Control files reside in there[color=blue]
>
>
> The postmaster then exits.
>
> What control file is it talking about?
> Is this a common error?[/color]

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

"pw" <p.willis@telus.net> writes:[color=blue]
> PANIC: invalid checksum in control file[/color]
[color=blue]
> What control file is it talking about?[/color]

$PGDATA/global/pg_control
[color=blue]
> Is this a common error?[/color]

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