Skip site navigation (1) Skip section navigation (2)

1) Error event produced during 8.0.3 shutdown. 2) Likely wrong interruption time reported in log files (8.0.0 and 8.0.3).

From: "Knut P Lehre" <k(dot)p(dot)lehre(at)world-online(dot)no>
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: 1) Error event produced during 8.0.3 shutdown. 2) Likely wrong interruption time reported in log files (8.0.0 and 8.0.3).
Date: 2005-07-20 11:56:26
Message-ID: 42BFF0FF0000048D@cpfe6.be.tisc.dk (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
1) During postgresql 8.0.3 shutdown (net stop postgresql) Error events appear
in WinXP Pro and Win Server 2003. I didn't see this before upgrading to
8.0.3 from 8.0.0.
Error Category: None, Event 0, User N/A.


2) The pgsql server was interrupted
a few times, likely because of a hardware
problem. I wanted to check at what time the server had been interrupted,
and found the following info in the log files:

From 1st log file, restart after planned shutdown for backup at 05:00:00
(running ve
sion 8.0.0):

2005-04-21 05:55:15  LOG:  database system was shut down at 2005-04-21 05:00:00
W. Europe Daylight Time
2005-04-21 05:55:15  LOG:  database system is ready

From 2nd log file, automatic restart after likely hardware failure:

2005
04-21 07:07:32  LOG:  database system was interrupted at 2005-04-21
05:55:15 W. Europe Daylight Time
2005-04-21 07:07:32  LOG:  database system is ready

Note that interruption time is identical to the last startup time.
And similar some weeks lat
r (after upgrade to 8.0.3):

From 1st file:

2005-05-31 05:57:52  LOG:  database system was shut down at 2005-05-31 05:00:00
W. Europe Daylight Time
2005-05-31 05:57:52  LOG:  database system is ready

From 2nd file:

2005-05-31 09:43:04  LOG
  database system was interrupted at 2005-05-31
05:57:52 W. Europe Daylight Time
2005-05-31 09:43:04  LOG:  database system is ready


The reported pg interruption times also did not match the timestamps produced
by other processes during the har
ware events. Could it be that the logger
uses a wrong time stamp for the interruption time report?




pgsql-hackers-win32 by date

Next:From: Obe, Regina DND\MISDate: 2005-07-20 13:08:07
Subject: Re: Manual installation of PostgreSQL 8
Previous:From: Andrew DunstanDate: 2005-07-19 13:56:31
Subject: Re: Manual installation of PostgreSQL 8

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group