Gossamer Forum
Home : General : Databases and SQL :

Postgres data dir and compilation.HELP!!!!

Quote Reply
Postgres data dir and compilation.HELP!!!!
Hi!
It was one those days when our Debian server is crushed.
So i contacted host company and they put new HD on it and install FreeBSD.
Well right now when i'm trying to run postgres with data from a old HD i'm getting next error.

$ /usr/local/pgsql/bin/postmaster -D /home/netsonic/home/test/postgres/data
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with HAVE_INT64_TIMESTAMP but the server was compiled without HAVE_INT64_TIMESTAMP.
HINT: It looks like you need to recompile or initdb.

And i can see why but i don't what to recomplile the server for that. So my question is. Is the any way to get this running temporary and dump data from it?

Thanks a lot
Dmitry