Thread: Problem with PostgreSQL 8.1.3 on Windows XP Pro
Hello,
I have an XP Pro Box, 1 Go RAM, 160 Go HD, with PostgreSQL 8.1.3 win32.
The service pgsql-8.1 appear to be started,
but when I try to connect with PgAdmin III 1.4.1, it hangs and I need to terminate the program.
The pg_log gave :
2006-02-28 15:36:52 LOG: database system was shut down at 2006-01-30 10:43:05 Paris, Madrid
2006-02-28 15:36:52 LOG: checkpoint record is at 0/C424CFE0
2006-02-28 15:36:52 LOG: redo record is at 0/C424CFE0; undo record is at 0/0; shutdown TRUE
2006-02-28 15:36:52 LOG: next transaction ID: 150552; next OID: 35291
2006-02-28 15:36:52 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2006-02-28 15:36:52 LOG: database system is ready
2006-02-28 15:36:52 LOG: transaction ID wrap limit is 2147484148, limited by database "postgres"
2006-02-28 15:36:52 WARNING: corrupted pgstat.stat file
2006-02-28 15:36:52 LOG: corrupted pgstat.stat file
2006-02-28 15:36:52 LOG: checkpoint record is at 0/C424CFE0
2006-02-28 15:36:52 LOG: redo record is at 0/C424CFE0; undo record is at 0/0; shutdown TRUE
2006-02-28 15:36:52 LOG: next transaction ID: 150552; next OID: 35291
2006-02-28 15:36:52 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2006-02-28 15:36:52 LOG: database system is ready
2006-02-28 15:36:52 LOG: transaction ID wrap limit is 2147484148, limited by database "postgres"
2006-02-28 15:36:52 WARNING: corrupted pgstat.stat file
2006-02-28 15:36:52 LOG: corrupted pgstat.stat file
It seems that pgstat.stat would be corrupted, what can I do ?
Best regards.
Luc
Attachment
"Ets ROLLAND" <ets@rolland-fr.com> writes:
> 2006-02-28 15:36:52 WARNING: corrupted pgstat.stat file
> 2006-02-28 15:36:52 LOG: corrupted pgstat.stat file
If this happened once, immediately after an update from a pre-8.1.3
version, then it's expected and you can ignore it. If it's happening
repeatably then there is cause for worry.
regards, tom lane