[GENERAL] building a binary-portable database

2009-07-31 Thread Alexy Khrabrov
I've filled a database on Linux and tried to bring it across to Mac OSX, and got an error: FATAL: incorrect checksum in control file. Exploring with pg_controldata shows differences such as: Linux: pg_control version number:833 Catalog version number: 200711281 Database

Re: [GENERAL] building a binary-portable database

2009-07-31 Thread Alexy Khrabrov
On Jul 31, 2009, at 6:30 PM, John R Pierce wrote: Alexy Khrabrov wrote: I've filled a database on Linux and tried to bring it across to Mac OSX, and got an error: FATAL: incorrect checksum in control file. use pg_dumpall | psql to export/import databases between machines. That

Re: [GENERAL] building a binary-portable database

2009-08-01 Thread Alexy Khrabrov
On Aug 1, 2009, at 8:24 AM, Alban Hertroys wrote: On 1 Aug 2009, at 24:53, Alexy Khrabrov wrote: That's doable of course, but I wonder what would it take to get it to work as-is, when building pg from source on each box, giving their fairly similar characteristics. Or, if time

Re: [GENERAL] building a binary-portable database

2009-08-02 Thread Alexy Khrabrov
How about portability between systems with the same endianness and bitness, e.g. Intel 64-bit ones? Cheers, Alexy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general