Re: Problems Restarting PostgreSQL Daemon

On Wed, 23 Jul 2008, Andrej Ricnik-Bay wrote:

> Now there's an interesting piece of information :) How long
> ago did you upgrade it?

Andrej,

A month ago; June 17th to be exact.

> From which version of pg to which version did you upgrade,

From 8.1.13 to 8.3.3.

> and how did you go about it? Chances are indeed that the postmasters
> logfile (/var/log/postgres) may hold crucial information as Tom suggested.

Well, after digging myself into a hole, I received help here and climbed
out. It was working last week (when I made some entries into my accounting
system and viewed the local version of our web site). However, ...

... 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?

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