Re: error restarting DB

On 08/27/2014 02:19 PM, John R Pierce wrote:
> On 8/27/2014 2:17 PM, Prabhjot Sheena wrote:
>> Database postgresql 8.4
>>
>> i shutdown the database and restarted database and now its not
>> starting and i m getting this error
>>
>> [caesius(at)dbtest05 pg_log]$ 2014-08-27 14:14:24 PDT FATAL: database
>> files are incompatible with server
>> 2014-08-27 14:14:24 PDT DETAIL: The database cluster was
>> initialized without HAVE_INT64_TIMESTAMP but the server was compiled
>> with HAVE_INT64_TIMESTAMP.

The basic problem is the above where the database cluster was
initialized using float timestamps and the server binary was compiled
with integer timestamps. As John already posted, this could be you are
doing -D $PG_DATA on the wrong cluster. The other way this can happen is
if you shutdown the server, moved another (incompatible)cluster into the
data directory and then restarted the server.

>> 2014-08-27 14:14:24 PDT HINT: It looks like you need to recompile
>> or initdb.
>
> is it possible you have two different builds of the postgres software on
> this system, and you inadvertently started a different one than the one
> you've been using ?
>
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com