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