Re: [GENERAL] PostgreSQL service won't start after bad computer time

2011-06-03 Thread Rob Richardson
My thanks for your replies. We used pg_resetxlog to clear things up. The database was not in active use, so the loss of the transactions didn't matter. RobR -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mail

Re: [GENERAL] PostgreSQL service won't start after bad computer time

2011-06-03 Thread Tom Lane
Bill Moran writes: > On 6/3/11 8:52:15 AM, Rob Richardson wrote: >> 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:56 EDTLOG:

Re: [GENERAL] PostgreSQL service won't start after bad computer time

2011-06-03 Thread Bill Moran
On 6/3/11 8:52:15 AM, Rob Richardson wrote: 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

[GENERAL] PostgreSQL service won't start after bad computer time

2011-06-03 Thread Rob Richardson
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:5