Re: Problems Restarting PostgreSQL Daemon

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems Restarting PostgreSQL Daemon
Date: 2008-07-23 01:44:06
Message-ID: 1216777446.24920.41.camel@jd-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2008-07-22 at 18:05 -0700, Rich Shepard wrote:
> On Wed, 23 Jul 2008, Andrej Ricnik-Bay wrote:
>
> > Now there's an interesting piece of information :) How long
> > ago did you upgrade it?
>

> ... something broke during the reboot. From /var/log/postgresql:
>
> FATAL: database files are incompatible with server
> DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 812,
> but the server was compiled with PG_CONTROL_VERSION 833.
> HINT: It looks like you need to initdb.
>
> I still have the old pgsql (8.1.13) still in a non-standard directory. I
> had run initdb after cleaning up the upgrade. Should I do so again?

It looks to me like your init script just isn't pointing to the 8.3.3
data directory. If you are unsure you can do this:

find / -name PG_VERSION

You likely have 2 or 3 of them. Find the one that says 8.3 and make sure
your start up script points there.

Joshua D. Drake

>
> Thanks,
>
> Rich
>
> --
> Richard B. Shepard, Ph.D. | Integrity Credibility
> Applied Ecosystem Services, Inc. | Innovation
> <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
>
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Martin 2008-07-23 03:07:39 Re: Substitute a variable in PL/PGSQL.
Previous Message Rich Shepard 2008-07-23 01:05:54 Re: Problems Restarting PostgreSQL Daemon