Balázs Keresztury <balazs.keresztury@xxxxxxxxx> 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@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
