Hi
The O/S is Win 2K Server SP4 and PG version is 8.0. Here's the log file from the latest incident:
2006-06-16 09:40:01 LOG: 00000: server process (PID 4744) was terminated by signal 125
2006-06-16 09:40:01 LOCATION: LogChildExit, postmaster.c:2335
2006-06-16 09:40:01 LOG: 00000: terminating any other active server processes
2006-06-16 09:40:01 LOCATION: HandleChildCrash, postmaster.c:2228
2006-06-16 09:40:02 WARNING: 57P02: terminating connection because of crash of another server process
2006-06-16 09:40:02 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2006-06-16 09:40:02 HINT: In a moment you should be able to reconnect to the database and
repeat your command.
2006-06-16 09:40:02 LOCATION: quickdie, postgres.c:1890
2006-06-16 09:40:03 LOG: 00000: all server processes terminated; reinitializing
2006-06-16 09:40:03 LOCATION: reaper, postmaster.c:2127
2006-06-16 09:40:04 LOG: 00000: database system was interrupted at 2006-06-15 20:03:42 GMT Daylight Time
2006-06-16 09:40:04 LOCATION: StartupXLOG, xlog.c:4054
2006-06-16 09:40:04 LOG: 00000: checkpoint record is at 0/3C5B5350
2006-06-16 09:40:04 LOCATION: StartupXLOG, xlog.c:4123
2006-06-16 09:40:04 LOG: 00000: redo record is at 0/3C5B5350; undo record is at 0/0; shutdown FALSE
2006-06-16 09:40:04 LOCATION: StartupXLOG, xlog.c:4151
2006-06-16 09:40:04 LOG: 00000: next transaction ID: 2991949; next OID: 182344
2006-06-16 09:40:04 LOCATION: StartupXLOG, xlog.c:4154
2006-06-16 09:40:04 LOG: 00000: database system was not properly shut down; automatic recovery in progress
2006-06-16 09:40:04 LOCATION: StartupXLOG, xlog.c:4210
2006-06-16 09:40:04 LOG: 00000: record with zero length at 0/3C5B5390
2006-06-16 09:40:04 LOCATION: ReadRecord, xlog.c:2487
2006-06-16 09:40:04 LOG: 00000: redo is not required
2006-06-16 09:40:04 LOCATION: StartupXLOG, xlog.c:4312
2006-06-16 09:40:04 LOG: 00000: database system is ready
2006-06-16 09:40:04 LOCATION: StartupXLOG, xlog.c:4517
Thanks
Ch.
Copy addresses and emails from any email account to Yahoo! Mail - quick, easy and free. Do it now...
