Re: restoring to different architecture with WAL

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: Balázs Keresztury <balazs(dot)keresztury(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: restoring to different architecture with WAL
Date: 2013-03-11 18:07:45
Message-ID: 877gldq07i.fsf@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Balázs Keresztury <balazs(dot)keresztury(at)gmail(dot)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2013-03-11 18:12:33 speeding up ALTER ... SET NOT NULL
Previous Message Tom Lane 2013-03-11 17:46:58 Re: Upgrading postgresql-8.4