Balázs Keresztury wrote:
> I have a postgres 8.4 on a Ubuntu box at my workplace [...]
> I already created the base backup with pg_start_backup and transferred to my computer, which is
> currently running Windows. The problem is that I can't even start up the base cluster, because
> postgres throws the following exception. Is there any way to circumvent this problem or should I stick
> to the pg_dump-pg_restore method?
>
> c:\Program Files (x86)\PostgreSQL\8.4\bin>2013-03-07 22:11:16 CET FATAL: database files are
> incompatible with server
> 2013-03-07 22:11:16 CET DETAIL: The database cluster was initialized with USE_FLOAT8_BYVAL but the
> server was compiled without USE_FLOAT8_BYVAL.
> 2013-03-07 22:11:16 CET HINT: It looks like you need to recompile or initdb.
You will have to stick with pg_dump/pg_restore.
It is not possible to restore a backup on a different architecture.
Yours,
Laurenz Albe