version Postgresql 9.1.1 on centos5 x64
We experience slow performance and found the server is running 3 vacuum
process on the same db which use up 99% of CPU.
Then we kill -9 one of those process which cause postgresql to crash and it
tried to restart after the crash
However when the starting process reach the last WAL files, it just stuck
pg_controldata shows the db is in Archive Recovery mode and when using psql
to connect the db, it says FATAL: the database system starting up.
I took a chance and upgrade to PostgreSql 9.1.2 and see if anything changed
it still stuck at the end of recovery.
pg_controldata shows db is in Crash recovery, but that probably different
wording I think
using psql to connect the db, it says FATAL: the database system is
I pretty much run out of idea here.
Can anyone help what to go from here?
pgsql-admin by date
|Next:||From: David Hornsby||Date: 2012-01-19 14:30:56|
|Subject: Re: Help! PostgreSQL stuck at starting up after crash|
|Previous:||From: Kevin Grittner||Date: 2012-01-18 22:33:04|
|Subject: Re: Upgrading from 9.0.3 to latest|