Thread: Moving DB von Postgresql 7.3 to 7.4

Moving DB von Postgresql 7.3 to 7.4

From
Tobias Graf
Date:
Hallo,

I've a quick question about a problem I have moving a database from V7.3
to V7.4.

I have an old database in version 7.3, unfortunately on my system
(Debian Sarge) the version 7.4 is installed, so the server will not
start. I downloaded V7.3 and compiled it, which worked fine, but when I
now start the server, I get the following message in the log:

PANIC:  The database cluster was initialized with HAVE_INT64_TIMESTAMP
        but the backend was compiled without HAVE_INT64_TIMESTAMP.
        It looks like you need to recompile or initdb.

I like to recompile with HAVE_INT64_TIMESTAMP, but I couldn't find out,
how to tell "./configure".

Best Regards,
Tobias


Re: Moving DB von Postgresql 7.3 to 7.4

From
Tom Lane
Date:
Tobias Graf <tobias.graf@gmx.net> writes:
> I like to recompile with HAVE_INT64_TIMESTAMP, but I couldn't find out,
> how to tell "./configure".

--enable-integer-timestamps, I think.  See "./configure --help".

            regards, tom lane