| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alexy Khrabrov <deliverable(at)gmail(dot)com> |
| Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: building a binary-portable database |
| Date: | 2009-07-31 23:09:53 |
| Message-ID: | 16545.1249081793@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alexy Khrabrov <deliverable(at)gmail(dot)com> 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 different, would it be a show-stopper?
The pg_controldata output suggests that indeed time_t size difference is
the immediate issue. But there might be other ones lurking behind that.
(FWIW, 8.4 has removed this particular potential platform difference:
http://archives.postgresql.org/pgsql-committers/2008-02/msg00184.php
But I still wouldn't trust copying DB files between significantly
different OSes.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Munro | 2009-07-31 23:58:07 | Re: Design Database, 3 degrees of Users. |
| Previous Message | Tom Lane | 2009-07-31 22:57:13 | Re: Make check fails on 8.3.7 |