| 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: | Whole Thread | Raw Message | 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 |