From: | "Leon Mergen" <leon(at)solatis(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Unable to get postgres running after long time no vacuum |
Date: | 2007-07-07 10:58:02 |
Message-ID: | 5eaaef180707070358i6fbc96f2n298789d3e40d3426@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hello,
Okay, I was stupid -- I didn't check my database server for a while
(vacation), returned, and found out I didn't run vacuum for a too long
time:
bash-3.1$ psql --version
psql (PostgreSQL) 8.1.9
contains support for command-line editing
bash-3.1$ psql
psql: FATAL: database is not accepting commands to avoid wraparound
data loss in database "tsukku"
HINT: Stop the postmaster and use a standalone backend to vacuum
database "tsukku".
So, I tried to do so, but something weird is going on and I cannot
find out what is going wrong, and how to solve it. I follow the
process of shutting down the database server, and started postgres
like this:
bash-3.1$ postgres --version
postgres (PostgreSQL) 8.1.9
bash-3.1$ postgres -D /var/lib/pgsql/data tsukku
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!
The problem also occurs if I just start postgres in single-user mode
instead of the entire service.
What I'm in now is some kind of loop of being unable to get postgres
back up -- anyone has any idea what I can do to find out what the
problem is, and what I can do to solve it ?
Thanks in advance!
Regards,
Leon Mergen
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2007-07-07 11:47:32 | Re: How to retrieve number of rows affected, in an after statement trigger? |
Previous Message | Leon Mergen | 2007-07-07 10:57:12 | Unable to get postgres running after long time no vacuum |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-07-07 13:00:43 | Re: Tidied up patch status page |
Previous Message | Stefan Kaltenbrunner | 2007-07-07 09:59:18 | Re: Tidied up patch status page |