| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | Balázs Keresztury *EXTERN* <balazs(dot)keresztury(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: restoring to different architecture with WAL |
| Date: | 2013-03-11 11:06:31 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B057BD602@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2013-03-11 11:13:35 | Re: ERROR: relation "employees" does not exist |
| Previous Message | Albe Laurenz | 2013-03-11 11:00:29 | Re: PostgreSQL connect with Visual C++ |