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
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)? |
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 |