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