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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
