Обсуждение: error restarting DB

Database postgresql 8.4

i shutdown the database and restarted database and now its not starting and i m getting this error

 [caesius@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.

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

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@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.klaver@aklaver.com