Help in compiling 8.1.2 from source

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

Do you have an old initdb in your path? When are you seeing this error
message? During initdb?

---------------------------------------------------------------------------

The Doctor wrote:

iHELP!!

I compile postgresql 8.1.2

using:
./configure \
--prefix=/usr/local/pgsql \
--infodir=/usr/share/info \
--mandir=/usr/share/man \
--enable-debug \
--enable-depend \
--enable-cassert \
--enable-thread-safety \
--with-perl \
--with-openssl \
--with-gnu-ld

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?

--
Member - Liberal International
This is doctor@nl2k.ab.ca Ici doctor@nl2k.ab.ca
God Queen and country! Beware Anti-Christ rising!
Born 29 Jan 1969 Redhill Surrey UK

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

The Doctor <doctor@doctor.nl2k.ab.ca> writes:

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?

You forgot --enable-integer-datetimes, which your previous installation
was evidently built with.

regards, tom lane