Re: Unable to get postgres running after long time no vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Leon Mergen" <leon(at)solatis(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to get postgres running after long time no vacuum
Date: 2007-07-07 15:44:48
Message-ID: 2487.1183823088@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Leon Mergen" <leon(at)solatis(dot)com> writes:
> Now, I enter a 'vacuum verbose;' and wait for about a day (the
> database is 1TB in size) -- it completes, and I start the database
> again; it starts replaying the +- 1K WAL log files for a while, and
> after completion, I try to attempt to connect to the database and it
> *still* says it is not accepting commands to avoid wraparound data
> loss!

Where did these log files come from? You said nothing about a crash.
Perhaps you are not shutting down the standalone mode cleanly after
the vacuum?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2007-07-07 15:48:40 Re: Update a single row without firing its triggers?
Previous Message henryJack 2007-07-07 14:27:20 What secret resipy of PostgreSQL (insert more faster than delete)?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-07-07 16:56:36 Re: Tidied up patch status page
Previous Message Tom Lane 2007-07-07 15:40:17 Re: usleep feature for pgbench