Postgres Pro
Downloads
Home   >   mailing lists

Thread: Help in compiling 8.1.2 from source

Help in compiling 8.1.2 from source

From
The Doctor
Date:
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.

Re: Help in compiling 8.1.2 from source

From
Richard Huxton
Date:
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

Re: Help in compiling 8.1.2 from source

From
Bruce Momjian
Date:
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

Re: Help in compiling 8.1.2 from source

From
Tom Lane
Date:
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