From: Kevin Grittner <kgrittn@ymail.com>
To: Laura Horsky <lhorsky@gwoslabs.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL won't start
Date: Thu, 10 Sep 2015 21:39:58 +0000 (UTC)
Message-ID: <591533476.500736.1441921198320.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <CAKH15QBN6V3fDq0KkTjbeBG9Xjm84NaBXm9_NutF8tr4jMV0gg@mail.gmail.com>
References: <CAKH15QBN6V3fDq0KkTjbeBG9Xjm84NaBXm9_NutF8tr4jMV0gg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Laura Horsky <lhorsky@gwoslabs.com> wrote:
> I have a PostgreSQL server that was restarted. When it was
> brought back online,
That is pretty vague. Exactly how was it restarted? How was it
brought back online? Was it really just that, or was this a
restore from backup or a copy on a new machine?
Exactly what version of PostgreSQL is this?
> PostgreSQL fails to start with:
>
> ....LOG: database system was interrupted; last known up at ....
You didn't get a clean shutdown of the database server, so
something was done that was not optimal. We can't give very
detailed advice without knowing what. By the way, seeing
timestamps for the startup and the "last known up at" times would
provide at least some clue what might have happened.
> I have pg_dumps that were taken prior to failure that I can
> restore to if I can get PostgreSQL running again.
That's good. If you wrangle what you have into starting you should
hang onto those dumps for a while (maybe a few months) after you
are running again. You may need to fish some data out of them if
you later see corruption or missing data.
> How can I fix PostgreSQL? I have seen pg_resetxlog but there are
> so many warnings, I want to make sure that this is the tool to
> use.
First thing is to make a filesystem-level copy of the $PGDATA
directory tree, in case your recovery attempts make things worse.
pg_resetxlog may well allow the database to start, but you should
heed the warnings about pg_dump and restore of the result to
eliminate hidden corruption, and review after that to look for
damaged or missing data.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: kgrittn@ymail.com, lhorsky@gwoslabs.com
Subject: Re: PostgreSQL won't start
In-Reply-To: <591533476.500736.1441921198320.JavaMail.yahoo@mail.yahoo.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