From: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: PiTR and other architectures.... |
Date: | 2008-12-02 23:15:15 |
Message-ID: | 4935C183.6050104@rhyme.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Jeff Davis wrote:
> On Tue, 2008-12-02 at 16:21 +0200, Heikki Linnakangas wrote:
>
>> initdb on one platform, copy the data directory over to the other
>> system, and try to start postmaster. It will complain if the on-disk
>> format is not compatible.
>>
>> You can also run pg_controlinfo on both systems, and compare the
>> results. If the "Maximum data alignment", and all the values below it in
>> the pg_controlinfo output match, the formats are compatible.
>>
>
> I don't think these things will work for all differences that could be
> problematic. For instance, a GNU system has a different collation for
> the en_US locale than an OS X system. This means that the indexes built
> using en_US on one system can't be moved to the other.
>
> How would either of these tests be able to determine that the systems
> are incompatible?
>
>
wow...that's a little scary. Sounds like there is no trustworthy test I
can run. Other than the case of collation differences, are there any
other kinds of problems that would not be detected by even a postmaster
restart?
|/
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2008-12-02 23:44:28 | Re: PiTR and other architectures.... |
Previous Message | Robert Haas | 2008-12-02 22:52:07 | Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1 |