database files are incompatible with server, after computer restart

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: database files are incompatible with server, after computer restart
Date: 2006-08-29 01:35:56
Message-ID: 20060829013556.58969.qmail@web52914.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I installed and started PostgreSQL and it worked fine
for days. Then I restarted my computer and now I can't
start PostgreSQL ('pg_ctl -D pgdata -l pgdata/psql.log
start'). Here's what's in my log:

LOG: received immediate shutdown request
WARNING: terminating connection because of crash of
another server process
DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit,
because another server process exited abnormally and
possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to
the database and repeat your command.
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized without
HAVE_INT64_TIMESTAMP but the server was compiled with
HAVE_INT64_TIMESTAMP.
HINT: It looks like you need to recompile or initdb.

I guess my computer restart didn't agree with
PostgreSQL. But I've had crashes before and never had
a problem getting PostgreSQL going again. Anybody know
how to fix this? I also tried 'pg_resetxlog -f pgdata'
but still get the same error trying to start up.

Thanks,
csn
Mac OS 10.4.7
PostgreSQL 8.1.3

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-08-29 01:36:26 Re: Cutting the Gborg throat
Previous Message Dave Cramer 2006-08-29 00:55:37 Re: Cutting the Gborg throat