Problem with PostgreSQL 8.1.3 on Windows XP Pro

Started by Secrétariatabout 20 years ago2 messagesgeneral
Jump to latest
#1Secrétariat
ets@rolland-fr.com

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

It seems that pgstat.stat would be corrupted, what can I do ?
Best regards.

Luc

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Secrétariat (#1)
Re: Problem with PostgreSQL 8.1.3 on Windows XP Pro

"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