From: David Hornsby <david@beechglen.com>
To: Samuel Hwang <samuel@replicon.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Help! PostgreSQL stuck at starting up after crash
Date: Thu, 19 Jan 2012 09:30:56 -0500
Message-ID: <c78b6c9b2902d25546465ecb9ea71a12.squirrel@mail.beechglen.com> (raw)
In-Reply-To: <CAOPCsHHiKKWRAVNFfOUHtuzBW5JLaqQ1KNC_V_J-TamrpuRu=A@mail.gmail.com>
References: <CAOPCsHHiKKWRAVNFfOUHtuzBW5JLaqQ1KNC_V_J-TamrpuRu=A@mail.gmail.com>
Sounds like you have a corrupt wal files that you will have to reset the
wal logs with pgresetxlog.
http://www.postgresql.org/docs/8.2/static/app-pgresetxlog.html
This will result in missing transactions so before you do this shutdown
postgres and make a copy of the database files first. That way if you
don't like what happens you can always go back to the way things were.
Also right now would be a good time to evaluate your backup strategy,
which is a different topic for a different thread, but I can certainly
help with that as well.
-David Hornsby
> 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
> there
>
> 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
> starting up.
>
> I pretty much run out of idea here.
> Can anyone help what to go from here?
>
> Samuel
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: david@beechglen.com, samuel@replicon.com
Subject: Re: Help! PostgreSQL stuck at starting up after crash
In-Reply-To: <c78b6c9b2902d25546465ecb9ea71a12.squirrel@mail.beechglen.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox