Re: [GENERAL] building a binary-portable database

2009-08-02 Thread Tom Lane
Martijn van Oosterhout writes: > On Sun, Aug 02, 2009 at 12:02:41PM -0400, Alexy Khrabrov wrote: >> How about portability between systems with the same endianness and >> bitness, e.g. Intel 64-bit ones? > There's nothing to stop you trying, but there's been no effort in > making it work. Exact

Re: [GENERAL] building a binary-portable database

2009-08-02 Thread Martijn van Oosterhout
On Sun, Aug 02, 2009 at 12:02:41PM -0400, Alexy Khrabrov wrote: > How about portability between systems with the same endianness and > bitness, e.g. Intel 64-bit ones? Some parameters vary between compilers on the same platform. IIRC whether a long on a 64-bit platform is 64-bit depends on the c

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

Re: [GENERAL] building a binary-portable database

2009-08-02 Thread Martijn van Oosterhout
On Sun, Aug 02, 2009 at 01:42:13AM -0400, Alexy Khrabrov wrote: > Well, my question, of course, is, how come all those differences might > affect PG binary data so much -- portable design would try to minimize > such effects, wouldn't it? Does it optimize for all of the above > intentionally

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_t is differen

Re: [GENERAL] building a binary-portable database

2009-08-01 Thread Alban Hertroys
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_t is different, would it be a show-stopper? Fairly similar?

Re: [GENERAL] building a binary-portable database

2009-07-31 Thread Tom Lane
Alexy Khrabrov writes: > 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. It's not promised to work, and if it breaks you get to keep both pieces. > Or, if time_t is di

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's doable o

Re: [GENERAL] building a binary-portable database

2009-07-31 Thread John R Pierce
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or