Обсуждение: 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

Balázs Keresztury <balazs.keresztury@gmail.com> writes:

> hi,
> I have a postgres 8.4 on a Ubuntu box at my workplace, and I plan to implement continuous?backup with the WAL
> technique. This backup is mainly used to provide the usual backup for the company, but I would also like to use it as
> an almost always up-to-date copy for my personal computer, mainly for development purposes. Thus, no two-way
> synchronization required.?
> I could (actually I am) use pg_dump to get the full copy each time, but since the database is very big and the vpn is
> slowish, it would be significantly less pain to download only the changes in the WAL files.
> 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?

1. Start running Ubuntu.

2. Consider running Ubuntu in a VM on your windows box if you
   absolutely must run Windows at all.

Else, you are doomed to do a text import every time and of course,
this isn't going to scale.

HTH


> Thanks,
> Balazs
>
> c:\Program Files (x86)\PostgreSQL\8.4\bin>pg_ctl start -D d://documents//munka//postgres_data
> server starting
>
> 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.
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800