Postgres Pro
Downloads
Home   >   mailing lists

Thread: error restarting DB

error restarting DB

From
Prabhjot Sheena
Date:
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.



Can anyone suggest anything?


Thanks

Re: error restarting DB

From
John R Pierce
Date:
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.
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

Re: error restarting DB

From
Adrian Klaver
Date:
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