From: | "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | PostgreSQL service won't start after bad computer time |
Date: | 2011-06-03 12:52:15 |
Message-ID: | 04A6DB42D2BA534FAC77B90562A6A03D018A5CE8@server.rad-con.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I did some testing involving changing a computer's time, and left the
time one year early (6/3/2010 instead of 2011). The PostgreSQL service
now will not start up. Here's what the log says:
2011-06-03 08:46:50 EDTWARNING: autovacuum not started because of
misconfiguration
2011-06-03 08:46:50 EDTHINT: Enable the "track_counts" option.
2011-06-03 08:46:50 EDTLOG: database system shutdown was interrupted;
last known up at 2011-06-03 08:43:59 EDT
2011-06-03 08:46:50 EDTLOG: database system was not properly shut down;
automatic recovery in progress
2011-06-03 08:46:50 EDTLOG: redo starts at 9/6E08AAB8
2011-06-03 08:46:50 EDTFATAL: the database system is starting up
2011-06-03 08:46:50 EDTFATAL: the database system is starting up
2011-06-03 08:46:51 EDTFATAL: the database system is starting up
2011-06-03 08:46:52 EDTFATAL: the database system is starting up
2011-06-03 08:46:53 EDTFATAL: the database system is starting up
2011-06-03 08:46:54 EDTFATAL: the database system is starting up
2011-06-03 08:46:55 EDTFATAL: the database system is starting up
2011-06-03 08:46:55 EDTFATAL: the database system is starting up
2011-06-03 08:46:56 EDTLOG: record with zero length at 9/8E080968
2011-06-03 08:46:56 EDTLOG: redo done at 9/8E07FA78
2011-06-03 08:46:56 EDTLOG: last completed transaction was at log time
2010-06-03 08:11:17.531-04
2011-06-03 08:46:56 EDTFATAL: xlog flush request 18/A2BE3510 is not
satisfied --- flushed only to 9/8E080968
2011-06-03 08:46:56 EDTCONTEXT: writing block 0 of relation
global/1261_vm
2011-06-03 08:46:56 EDTLOG: startup process (PID 4596) exited with exit
code 1
2011-06-03 08:46:56 EDTLOG: aborting startup due to startup process
failure
How do we recover from this?
RobR
From | Date | Subject | |
---|---|---|---|
Next Message | Michal Politowski | 2011-06-03 13:03:57 | Re: Mixed up protocol packets in server response? |
Previous Message | tv | 2011-06-03 11:57:40 | Re: Interpreting EXPLAIN ANALYSE |