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
Bill Moran writes:
> On 6/3/11 8:52:15 AM, Rob Richardson wrote:
>> I did some testing involving changing a computers time, and left the
>> time one year early (6/3/2010 instead of 2011). The PostgreSQL service
>> now will not start up. Heres what the log says:
>>
>> 2011-06-03 08:46:56 EDTLOG:
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
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