Re: restoring to different architecture with WAL

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