Re: error restarting DB

John R Pierce <pierce@xxxxxxxxxxxx> · Wed, 27 Aug 2014 14:19:30 -0700



    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