The Doctor wrote:
iHELP!!
I compile postgresql 8.1.2
[snip]
and Now I am getting:
ns1# FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with HAVE_INT64_TIMESTAMP but the server was compiled without HAVE_INT64_TIMESTAMP.
HINT: It looks like you need to recompile or initdb.
What do I need to get this running again?
It looks like you either:
1. Have two versions of PG installed with different compilation options.
2. Have old data-files left behind from a previous installation and
haven't run initdb again.
3. Have recompiled your programs with different options.
Which is it?
--
Richard Huxton
Archonet Ltd